使用RegEx获取字符串的特定部分

Question

I'm trying to make a json file with all my countries cities and states (called departamentos here). I never found a complete list but now I'm following the list made by Wikipedia users in this link:

https://es.wikipedia.org/wiki/Anexo:Municipios_de_Colombia

I have copied and pasted all the text within a document, making a new line for each city like this:

Yacopí es una población y municipio del departamento de Cundinamarca

Currently I am able to select the city using RegEx with this expression:

/.+?(?= es)/

It takes everything from the beginning of the line to where it meets " es" for the first time, which is a regular convention for each of the lines in the Wikipedia page.

Now what I want to achieve is with the same line of Regex, also get the state which can be the last or last two words. Which I think it can be reached by selecting anything after " de ". But I'm stuck.

Any help would be appreciated and maybe other people around the world can start making json files out of Wikipedia.

Answer 1

This seems to work for at least the cities starting with an A. I didn't test all of them though.

/^(.*?) es.*de (.*)$/gm

Play with it here. https://regex101.com/r/yJ3gK7/1 (the whitespace is from pasting from the wiki, and shouldn't really matter here.)