regex101: PCRE (Legacy) Match Workspace

^start of line

recordthe literal text record (case insensitive)

Group id(?<id>\d+)

\d+a digit, repeated at least once

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

Character Class[0-9\#\$\%\-\+\,]+

+matches at least one character from the set below:

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

\#the literal # (35₁₀ / 43₈ / 23₁₆)

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

\%the literal % (37₁₀ / 45₈ / 25₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

\+the literal + (43₁₀ / 53₈ / 2B₁₆)

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

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

Group name(?<name>\w+)

\w+any word character, repeated at least once

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

Character Class[\D\,]+

+matches at least one character from the set below:

\Dany character that's not a digit

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

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

Group PostalCode(?<PostalCode>\d+)

\d+a digit, repeated at least once

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

Character Class[0-9\#\$\%\-\+\,]+

+matches at least one character from the set below:

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

\#the literal # (35₁₀ / 43₈ / 23₁₆)

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

\%the literal % (37₁₀ / 45₈ / 25₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

\+the literal + (43₁₀ / 53₈ / 2B₁₆)

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

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

Group Status(?<Status>(true|false))

Group 5(true|false)

1st Alternativetrue

truethe literal text true (case insensitive)

2nd Alternativefalse

falsethe literal text false (case insensitive)

,Endthe literal text ,End (case insensitive)

$end of line

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

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Search reference

Regular Expression

^record(?<id>\d+),[0-9\#\$\%\-\+\,]+,(?<name>\w+),[\D\,]+,(?<PostalCode>\d+),[0-9\#\$\%\-\+\,]+,(?<Status>(true|false)),End$

New

record18,$65535,sisoog,do,5463213,33436,12,18,-17,+16,78,trUe,End
record15,#15,25,45,sisoog,s,is,oog,5463213,6,-7,78,33-43,True,End
record16,55,-35,sisoog,End,use,wait,546365213,#88,15,5485,False,End
record17,15,-45,351,sisoog,do,wait,smit,5463213,33-436,faLse,End
record17,15,-45,351,sisoog,do,smit,5463213,3436,End

Regular Expressions 101

Regular Expression

Extraction