Regular Expressions 101

Non-Capturing Group(?:\s*(?=\w+\.|.*as\s+|distinct\s+|)(\*|\w+)(?=\s*(?=,|from)))

\s*any whitespace character, repeated any number of times

Positive Lookahead(?=\w+\.|.*as\s+|distinct\s+|)

1st Alternative\w+\.

\w+any word character, repeated at least once

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

2nd Alternative.*as\s+

.*any character (except for line terminators), repeated any number of times

asthe literal text as (case insensitive)

\s+any whitespace character, repeated at least once

3rd Alternativedistinct\s+

distinctthe literal text distinct (case insensitive)

\s+any whitespace character, repeated at least once

4th Alternative — matches an empty string

Group 1(\*|\w+)

1st Alternative\*

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

2nd Alternative\w+

\w+any word character, repeated at least once

Positive Lookahead(?=\s*(?=,|from))

\s*any whitespace character, repeated any number of times

Positive Lookahead(?=,|from)

1st Alternative,

,the literal , (44₁₀ / 54₈ / 2C₁₆)

2nd Alternativefrom

fromthe literal text from (case insensitive)

Global pattern flags

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

g modifier: global. Finds all matches instead of stopping after the first

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?:\s*(?=\w+\.|.*as\s+|distinct\s+|)(\*|\w+)(?=\s*(?=,|from)))

New

select distinct test, another_column, sum(data) as data_value, customtable.reported from customtable