Regular Expressions 101

Positive Lookbehind(?<=COLUMN[1,3]=\s)

COLUMNthe literal text COLUMN (case sensitive)

Character Class[1,3]

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

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

3the literal 3 (51₁₀ / 63₈ / 33₁₆)

=the literal = (61₁₀ / 75₈ / 3D₁₆)

\sany whitespace character

Group 1(\d.?\d*\s)*

*repeats the group contents below any number of times:

\da digit

.?optionally matches any character (except for line terminators)

\d*a digit, repeated any number of times

\sany whitespace character

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

(?<=COLUMN[1,3]=\s)(\d.?\d*\s)*

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

ExtractionProcessing...

Test String
New

Extraction
Processing...