Regular Expressions 101

Pro

(?i)applies the following effective flags to the remainder of the pattern: gi

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

Positive Lookbehind(?<=[^\w])

Negated Character Class[^\w]

\wany word character

Character Class[-+]?

?matches at most one character from the set below:

-the literal - (45₁₀ / 55₈ / 2D₁₆)

+the literal + (43₁₀ / 53₈ / 2B₁₆)

Character Class[\d\.]+

+matches at least one character from the set below:

\da digit

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

Group 1(e[-+]?\d+)?

?repeats the group contents below at most once:

ethe literal e (101₁₀ / 145₈ / 65₁₆) (case insensitive)

Character Class[-+]?

?matches at most one character from the set below:

-the literal - (45₁₀ / 55₈ / 2D₁₆)

+the literal + (43₁₀ / 53₈ / 2B₁₆)

\d+a digit, repeated at least once

Global pattern flags

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

Detailed match information will be displayed here automatically.

25 tokens

(?i)(?<=[^\w])[-+]?[\d\.]+(e[-+]?\d+)?

New

SELECT pop1990, pop2000, 500, -50,-0.5, -5E-100, 4e+20, 3e10
FROM foo
WHERE pop1990 IN (5, 100, 7.8,25;)