Using regular expressions to do mass replace in Notepad++
- by user638820
I've been trying to replace (and translate) this text, and i don't know what formula I should Use for thousands of places that I need to translate to Spanish. OKay this is what i want to do, i want to use regular expressions on Notepadd++.
I give 4 variations, and in bold is what's supposed to go after the name of the place, in lower case and not to be confused with eg. Agency Village because that's its name.
Missouri 5,988,927
Adrian City city 1,677
Advance city 1,347
Affton CDP 20,307
Agency Village village 684
Airport Drive village 698
To
| [[Adrian City (Misuri)|Adrian City]]
|| ciudad || 1677
|-
| [[Advance (Misuri)|Advance]] ||
ciudad || 1347
|-
| [[Afton (Misuri)|Afton]] || CDP || 20307
|-
| [[Agency Village (Misuri)|Agency
Village]] || villa || 684
|-
| [[Airport Drive (Misuri)|Airport
Drive]] || villa || 698