Replace partially matching values

[mlozovskaya]

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:

Thailand

India

Luxembourg

United Kingdom

Greece

France

Korea, Rep of

Brazil

India

Germany

Australia

Germany

[Qiu]

@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?

[messi007]

@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