regex101: PCRE (Legacy) Match Workspace

Pro

Non-Capturing Group(?:^[^,]*, |\G(?!^) AND )

1st Alternative^[^,]*,

^start of line

Negated Character Class[^,]*

*matches any number of characters outside the set below:

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

, the literal text ,

2nd Alternative\G(?!^) AND

\Gstart of current search

Negative Lookahead(?!^)

^start of line

AND the literal text AND (case sensitive)

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

.+?any character (except for line terminators), repeated at least once

Positive Lookahead(?= AND |$)

1st Alternative AND

AND the literal text AND (case sensitive)

2nd Alternative$

$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

25 tokens

Regular Expression

(?:^[^,]*, |\G(?!^) AND )\K.+?(?= AND |$)

New

NETHERLANDS (THE)
BOLIVIA (PLURINATIONAL STATE OF)
COCOS (KEELING) ISLANDS (THE)
ANTIGUA AND BARBUDA

TEST1, SOME TEXT
TEST2, SAINT HELENA AND ASCENSION AND TRISTAN DA CUNHA
TEST3, BONAIRE AND SINT EUSTATIUS AND SABA

Substitution

NETHERLANDS (THE)
BOLIVIA (PLURINATIONAL STATE OF)
COCOS (KEELING) ISLANDS (THE)
ANTIGUA AND BARBUDA

TEST1, SOME TEXT
TEST2, SAINT HELENA AND ASCENSION AND TRISTAN DA CUNHA
TEST3, BONAIRE AND SINT EUSTATIUS AND SABA