Regular Expressions 101

Positive Lookbehind(?<=\d\.\d*\*?)

\da digit

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

\d*a digit, repeated any number of times

\*?optionally matches the literal * (42₁₀ / 52₈ / 2A₁₆)

Group 1([\*\.,])

Character Class[\*\.,]

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

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

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

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.

Search reference

Regular Expression

(?<=\d\.\d*\*?)([\*\.,])

Test String
New

   1  ****TABLE1****
   COLUMN1= 1.12, 2.23, 3.34, 4.45, 5.56, 6.67, 
   COLUMN2= 0.00, 0.00, 0.00, 0.00, 0.00, 0.00,
   COLUMN3= 1.23, 0.34, 3.45, 5.78*, 6.54*, 8.23.,
   1  ****TABLE2****

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...