Regular Expressions 101

1st Alternative(?<=\sAS\s).*(\[)

Positive Lookbehind(?<=\sAS\s)

\sany whitespace character

ASthe literal text AS (case sensitive)

\sany whitespace character

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

Group 1(\[)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

2nd Alternative](?<=\sAS\s).*?(\[)

]the literal ] (93₁₀ / 135₈ / 5D₁₆)

Positive Lookbehind(?<=\sAS\s)

\sany whitespace character

ASthe literal text AS (case sensitive)

\sany whitespace character

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

Group 2(\[)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

3rd Alternative(?<=\sAS\s)?(\])

Positive Lookbehind(?<=\sAS\s)?

?repeats the group contents below at most once:

\sany whitespace character

ASthe literal text AS (case sensitive)

\sany whitespace character

Group 3(\])

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

Global pattern flags

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

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

(?<=\sAS\s).*(\[)|](?<=\sAS\s).*?(\[)|(?<=\sAS\s)?(\])

New

,ISNULL([Gt 01 To 02 Weeks SUM 1],0) AS [Gt 01 To 02 Weeks SUM]
,ISNULL([Gt 02 To 03 Weeks SUM 1],0) AS [Gt 02 To 03 Weeks SUM]

,ISNULL([Gt 01 To 02 Weeks SUM 1],0) AS [Gt 01 To 02 Weeks SUM]
,ISNULL([Gt 02 To 03 Weeks SUM 1],0) AS [Gt 02 To 03 Weeks SUM]