Regular Expressions 101

Explanation

Pro

1st Alternative(NUMBER[(](\d{1,3},\d)[)])

Group 1(NUMBER[(](\d{1,3},\d)[)])

NUMBERthe literal text NUMBER (case insensitive)

Character Class[(]

(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group 2(\d{1,3},\d)

\d{1,3}a digit, repeated between 1 and 3 times

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

\da digit

Character Class[)]

)the literal ) (41₁₀ / 51₈ / 29₁₆)

2nd Alternative(NUMBER[(]((\d{1,3})|(\d{1,3}[,]\d))[)]((?=\/DECIMAL)|(?=\/PERCENTAGE)).*)

Group 3(NUMBER[(]((\d{1,3})|(\d{1,3}[,]\d))[)]((?=\/DECIMAL)|(?=\/PERCENTAGE)).*)

NUMBERthe literal text NUMBER (case insensitive)

Character Class[(]

(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group 4((\d{1,3})|(\d{1,3}[,]\d))

1st Alternative(\d{1,3})

Group 5(\d{1,3})

\d{1,3}a digit, repeated between 1 and 3 times

2nd Alternative(\d{1,3}[,]\d)

Group 6(\d{1,3}[,]\d)

\d{1,3}a digit, repeated between 1 and 3 times

Character Class[,]

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

\da digit

Character Class[)]

)the literal ) (41₁₀ / 51₈ / 29₁₆)

Group 7((?=\/DECIMAL)|(?=\/PERCENTAGE))

1st Alternative(?=\/DECIMAL)

Positive Lookahead(?=\/DECIMAL)

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

DECIMALthe literal text DECIMAL (case insensitive)

2nd Alternative(?=\/PERCENTAGE)

Positive Lookahead(?=\/PERCENTAGE)

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

PERCENTAGEthe literal text PERCENTAGE (case insensitive)

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

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

(NUMBER[(](\d{1,3},\d)[)])|(NUMBER[(]((\d{1,3})|(\d{1,3}[,]\d))[)]((?=\/DECIMAL)|(?=\/PERCENTAGE)).*)

New

NUMBER(12)
NUMBER(12)/NUMBER
NUMBER(1)
NUMBER(1)/NUMBER
(100)
DATATYPE=NUMBER
NUMBER
NUMBER()
NUMBER(10,2)/PERCENTAGE
NUMBER(12)/DECIMAL
NUMBER(12,4)
NUMBER(13,4)
NUMBER(15)/DECIMAL
NUMBER(15,2)
NUMBER(16)/DECIMAL
NUMBER(10,3)/DECIMAL
NUMBER(3)/DECIMAL
NUMBER(3)/PERCENTAGE
NUMBER(4)/DECIMAL
NUMBER(4,1)
NUMBER(4,2)
NUMBER(5)/DECIMAL
NUMBER(5)/PERCENTAGE
NUMBER(5,2)
NUMBER(5,2)/PERCENTAGE
NUMBER(6)/DECIMAL
NUMBER(7)/DECIMAL
NUMBER(8)/DECIMAL
NUMBER/
NUMBER/CURRENCY
NUMBER/DECIMAL
NUMBER/IFS CURRENCY
NUMBER/INVISIBLE
NUMBER/NUMBER
NUMBER/PERCENTAGE
NUMBER/UPPERCASE
NUMBER=
Number
number

Substitution

NUMBER(12)
NUMBER(12)/NUMBER
NUMBER(1)
NUMBER(1)/NUMBER
(100)
DATATYPE=NUMBER
NUMBER
NUMBER()
NUMBER(10,2)/PERCENTAGE
NUMBER(12)/DECIMAL
NUMBER(12,4)
NUMBER(13,4)
NUMBER(15)/DECIMAL
NUMBER(15,2)
NUMBER(16)/DECIMAL
NUMBER(10,3)/DECIMAL
NUMBER(3)/DECIMAL
NUMBER(3)/PERCENTAGE
NUMBER(4)/DECIMAL
NUMBER(4,1)
NUMBER(4,2)
NUMBER(5)/DECIMAL
NUMBER(5)/PERCENTAGE
NUMBER(5,2)
NUMBER(5,2)/PERCENTAGE
NUMBER(6)/DECIMAL
NUMBER(7)/DECIMAL
NUMBER(8)/DECIMAL
NUMBER/
NUMBER/CURRENCY
NUMBER/DECIMAL
NUMBER/IFS CURRENCY
NUMBER/INVISIBLE
NUMBER/NUMBER
NUMBER/PERCENTAGE
NUMBER/UPPERCASE
NUMBER=
Number
number