data parse

[umairah]

Hi, I want to get only the country name and the economic performance  for further extraction and not sure suitable expression in regex tool to get the data. Any help is really helpful.

I will attached sample data for your reference.

[fmvizcaino · Accepted solution]

Hi @umairah ,

It is totally possible to do all with one regex expression, but I'm showing here another way separating only country name with regex and text to column for the rest.

Best,

Fernando Vizcaino

[seinchyiwoo]

or alternatively using tokenize in regex tool to parse out the numbers: 

final output as below: