Regular Expressions 101

Pro

Non-Capturing Group(?:\"|)

1st Alternative\"

\"the literal " (34₁₀ / 42₈ / 22₁₆)

2nd Alternative — matches an empty string

\ban ASCII word boundary

\w*any word character, repeated any number of times

Character Class[a-zA-Z]

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

\w*any word character, repeated any number of times

Non-Capturing Group(?:[\"\.]{1,3})

Character Class[\"\.]{1,3}

{1,3}matches between 1 and 3 characters from the set below:

\"the literal " (34₁₀ / 42₈ / 22₁₆)

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

Non-Capturing Group(?:\w+\"|\w+)

1st Alternative\w+\"

\w+any word character, repeated at least once

\"the literal " (34₁₀ / 42₈ / 22₁₆)

2nd Alternative\w+

\w+any word character, repeated at least once

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

(?:\"|)\b\w*[a-zA-Z]\w*(?:[\"\.]{1,3})(?:\w+\"|\w+)

New

CASE WHEN "SOME_TABLE"."Some_Column" LIKE 'A' THEN "Another_TBL"."Another_col" ELSE 'B' END

CASE WHEN "SOME_TABLE"."Some_Column" LIKE 'A' THEN "Another_TBL"."Another_col" ELSE 'B' END