regex101: PCRE (Legacy) Substitution Workspace

Non-Capturing Group(?: #start by finding the initial position of the table start, in order to store the match position for \G TABLE\n\K| #after we've found the table head, continue matching using this position. make sure we arent at the beginning of the string \G(?<!^) )

1st Alternative #start by finding the initial position of the table start, in order to store the match position for \G TABLE\n\K

#start by finding the initial position of the table start, in order to store the match position for the literal text ↵ #start by finding the initial position of the table start, in order to store the match position for (case sensitive)

\Gstart of current search

TABLEthe literal text ↵ TABLE (case sensitive)

\na line-feed (newline) character (ASCII 10)

\Kresets the starting point of the reported match. Any previously consumed characters are no longer included in the final match

2nd Alternative #after we've found the table head, continue matching using this position. make sure we arent at the beginning of the string \G(?<!^)

#after we've found the table head, continue matching using this positionthe literal text ↵ #after we've found the table head, continue matching using this position (case sensitive)

.any character (except for line terminators)

make sure we arent at the beginning of the string the literal text make sure we arent at the beginning of the string↵ (case sensitive)

\Gstart of current search

Negative Lookbehind(?<!^)

^start of string

the literal ↵ (10₁₀ / 12₈ / A₁₆)

#capture the data we're interested in the literal text ↵#capture the data we're interested in↵ (case sensitive)

Non-Capturing Group(?: #make sure there is no 'END' in the string (?!END) #match everything until the line ending . )*

*repeats the group contents below any number of times:

#make sure there is no 'END' in the string the literal text ↵ #make sure there is no 'END' in the string↵ (case sensitive)

Negative Lookahead(?!END)

ENDthe literal text END (case sensitive)

#match everything until the line ending the literal text ↵ #match everything until the line ending↵ (case sensitive)

.any character (except for line terminators)

the literal ↵ (10₁₀ / 12₈ / A₁₆)

#consume the newline at the end of the string the literal text ↵#consume the newline at the end of the string↵ (case sensitive)

\na line-feed (newline) character (ASCII 10)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Search reference

Regular Expression

(?:
    #start by finding the initial position of the table start, in order to store the match position for \G
    TABLE\n\K|
    #after we've found the table head, continue matching using this position. make sure we arent at the beginning of the string
    \G(?<!^)
)
#capture the data we're interested in
(?:
    #make sure there is no 'END' in the string
    (?!END)
    #match everything until the line ending
    .
)*
#consume the newline at the end of the string
\n

New

Regular Expressions 101

Regular Expression

Extraction