Regular Expressions 101

Pro

Group 1([0-9]+\.)+

+repeats the group contents below at least once:

Character Class[0-9]+

+matches at least one character from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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

Character Class[0-9]*

*matches any number of characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

_to_the literal text _to_ (case sensitive)

Group 2([0-9]+\.)+

+repeats the group contents below at least once:

Character Class[0-9]+

+matches at least one character from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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

Character Class[0-9]*

*matches any number of characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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

sqlthe literal text sql (case sensitive)

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

([0-9]+\.)+[0-9]*_to_([0-9]+\.)+[0-9]*\.sql

New

.0_to_..sql

0_to_.1.sql

11.1.1.1_to_21.1.1.1asql

1.1_to_2.1.sql

11.1.1.1_to_21.1.1.1.sql

.0_to_..sql

0_to_.1.sql

11.1.1.1_to_21.1.1.1asql

1.1_to_2.1.sql

11.1.1.1_to_21.1.1.1.sql