Regular Expressions 101

#Sectionthe literal text #Section (case sensitive)

Group 1(\d+)

\d+a digit, repeated at least once

Non-Capturing Group(?:(?!#Section\d).)*

*repeats the group contents below any number of times:

Negative Lookahead(?!#Section\d)

#Sectionthe literal text #Section (case sensitive)

\da digit

.any character (except for line terminators)

\ban ASCII word boundary

Jack/M,the literal text Jack/M, (case sensitive)

Group 2(\d+)

\d+a digit, repeated at least once

\h+any horizontal whitespace character, repeated at least once

Group 3(\d+(?:\.\d+)?)

\d+a digit, repeated at least once

Non-Capturing Group(?:\.\d+)?

?repeats the group contents below at most once:

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

\d+a digit, repeated at least once

\sany whitespace character

Group 4(\d+)

\d+a digit, repeated at least once

\h+any horizontal whitespace character, repeated at least once

Group 5([-+]?\d+(?:\.\d+)?)

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

Non-Capturing Group(?:\.\d+)?

?repeats the group contents below at most once:

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

\d+a digit, repeated at least once

\ban ASCII word boundary

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

#Section(\d+)(?:(?!#Section\d).)*\bJack/M,(\d+)\h+(\d+(?:\.\d+)?)\s(\d+)\h+([-+]?\d+(?:\.\d+)?)\b

New

#Section250342,Main,First/HS/12345/Jack/M,200010 10.00 200011 -2.00,
#Section250322,Main,First/HS/12345/Aaron/N,200010 17.00,
#Section250399,Main,First/HS/12345/Jimmy/N,200010 12.00,
#Section251234,Main,First/HS/12345/Jack/M,200011 11.00

Regular Expression

Extraction