Regular Expressions 101

Pro

1st Alternative"[^"]*"

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

Negated Character Class[^"]*

*matches any number of characters outside the set below:

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

2nd Alternative'[^']*'

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Negated Character Class[^']*

*matches any number of characters outside the set below:

'the literal ' (39₁₀ / 47₈ / 27₁₆)

3rd Alternative\s+AS\s+

\s+any whitespace character, repeated at least once

ASthe literal text AS (case insensitive)

\s+any whitespace character, repeated at least once

4th Alternative\s*((?:(?!\sAS\s)[^\s,])+)

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

Group 1((?:(?!\sAS\s)[^\s,])+)

Non-Capturing Group(?:(?!\sAS\s)[^\s,])+

+repeats the group contents below at least once:

Negative Lookahead(?!\sAS\s)

\sany whitespace character

ASthe literal text AS (case insensitive)

\sany whitespace character

Negated Character Class[^\s,]

\sany whitespace character

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

Global pattern flags

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

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

Detailed match information will be displayed here automatically.

25 tokens

"[^"]*"|'[^']*'|\s+AS\s+|\s*((?:(?!\sAS\s)[^\s,])+)

New

Select id AS "cusId ", name as 'cusName', gendar as ' Gendar.', isPaid as " is'Paid " total , datetime FROM