Replace partially matching values

Question

I have a table with one column displayed incorrect country format. I would like to replace incorrect country list with correct one without changing the original file row order

Original file with incorrect country format

TH (Thailand)IN (India)LU (Luxembourg)UK (United Kingdom of Great Britain and Northern Ireland)UK (United Kingdom of Great Britain and Northern Ireland)FR (France)KS (Korea, Republic of (South))TW (Taiwan, Province of China[a])SP (Spain)LU (Luxembourg)BR (Brazil)IN (India)

Correct country format:

ThailandIndiaLuxembourgUnited KingdomGreeceFranceKorea, Rep ofBrazilIndiaGermanyAustraliaGermany

messi007 · Answer

@mlozovskaya,

If I understand well your needs is to get the correct format based on file that have good names.

If yes please see below

Please see below:

If not you can use Regex in order to parse :

Attached the workflow,

Hope that helps,

Regards

Parse.yxmd

Qiu · Answer

@mlozovskaya 
We use RecordID to give a sequence number of original records, then after processing, we can do the sorting by RecordID.

The courtry names, you need to parse them?