regex101: PCRE (Legacy) Substitution Workspace

.*any character (except for line terminators), repeated any number of times

Positive Lookbehind(?<=")

"the literal " (34₁₀ / 42₈ / 22₁₆)

Negative Lookahead(?!US|CN)

1st AlternativeUS

USthe literal text US (case sensitive)

2nd AlternativeCN

CNthe literal text CN (case sensitive)

Positive Lookahead(?=\w{2}"|")

1st Alternative\w{2}"

\w{2}any word character, repeated exactly 2 times

"the literal " (34₁₀ / 42₈ / 22₁₆)

2nd Alternative"

"the literal " (34₁₀ / 42₈ / 22₁₆)

.*any character (except for line terminators), repeated any number of times

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

Search reference

Regular Expression

.*(?<=")(?!US|CN)(?=\w{2}"|").*

New

[
[707860,"UA","Hurzuf"],
[519188,"RU","Novinki"],
[1283378,"NP","Gorkhā"],
[1270260,"IN","State of Haryāna"],
[708546,"UA","Holubynka"],
[1283710,"NP","Bāgmatī Zone"],
[529334,"RU","Mar’ina Roshcha"],
[529334,"US","Mar’ina Roshcha"],
[6255149,"","North America"],
[1269750,"IN","Republic of India"],
[1283240,"NP","Kathmandu"],
[703363,"UA","Laspi"],
[3632308,"VE","Merida"],
[473537,"CN","Vinogradovo"],
[473537,"RU","Vinogradovo"],
[384848,"IQ","Qarah Gawl al ‘Ulyā"],
[569143,"RU","Cherkizovo"],
[713514,"UA","Alupka"],
[2878044,"DE","Lichtenrade"],
]

Regular Expressions 101

Regular Expression

Extraction