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