Using regular expressions to do mass replace in Notepad++
        Posted  
        
            by 
                user638820
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by user638820
        
        
        
        Published on 2011-03-01T05:58:23Z
        Indexed on 
            2011/03/01
            7:24 UTC
        
        
        Read the original article
        Hit count: 550
        
notepad++
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
© Stack Overflow or respective owner