regex101: Look up corresponding value in unsorted list

Positive Lookbehind(?<="name": ")

"name": "the literal text "name": " (case sensitive)

Group 1(.+)

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

Group 2(",\n\s+"war_memorials": ")

",the literal text ",

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

\s+any whitespace character, repeated at least once

"war_memorials": "the literal text "war_memorials": " (case sensitive)

Group 3(.*?\1,)

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

\1the text saved by group 1

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

Group 4(.*?)

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

Group 5(,.*)

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

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

Positive Lookahead(?=",)

",the literal text ",

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

(?<="name": ")(.+)(",\n\s+"war_memorials": ")(.*?\1,)(.*?)(,.*)(?=",)

New

"properties": {
    "cartodb_id": 2,
    "sortcode": 3,
    "pop2011": 612431,
    "pop2002": 652625,
    "pop1992": 681206,
    "pop1977": 631918,
    "pop1966": 529833,
    "pop1956": 483741,
    "pop1948": 448964,
    "regionid": 3,
    "countycode": 38,
    "countyid": 3,
    "region": "Sud",
    "mnemonic": "AG",
    "name": "Argeș",
    "war_memorials": "București,132,Alba,145,Brașov,151,Covasna,100,Harghita,188,Mureș,363,Sibiu,165,Bacău,188,Botoșani,149,Iași,246,Neamț,235,Suceava,219,Vaslui,212,Bihor,199,Bistrița-Năsăud,120,Cluj,186,Maramureș,,Satu Mare,119,Sălaj,79,Brăila,47,Buzău,188,Constanța,89,Galați,,Tulcea,87,Vrancea,76,Argeș,252,Călărași,115,Dâmbovița,191,Giurgiu,180,Ialomița,113,Prahova,162,Teleorman,202,Dolj,212,Gorj,154,Mehedinți,110,Olt,163,Vâlcea,185,Arad,233,Caraș-Severin,176,Hunedoara,118,Timiș,321",
    "version": "2016-03-10T00:00:00Z",
    "comune": 95,
    "orase": "4"
  }
}

Substitution

\1\2\4