convert Country name to Country code

One Star

convert Country name to Country code

Ver: 5.1.1
Level : New
hi,
I have a input Access table with field "Land" containing country name. eg.
----------------
Land
----------------
France
Germany
United Kingdom
..
..
..
..
---------------
Now I would like to convert this to two letter international code in the new SQL database. So
---------------
France --> FR
Germany --> DE
United Kingdom --> UK
..
..
.. and so on.
---------------
I have the complete list for all countries.
I see that I can do it in tMap express builder. But its a over kill to write conditional statement like if = val:then:else for all countries.

Can any body suggest best way to handle this situation ?
One Star

Re: convert Country name to Country code

Hi
You'd better create a referrence table which contains two columns.
One is the entire country name(e.g. United Kingdom). The other is abbreviation (e.g. UK).
Then do inner join in tMap with the access table and this referrence table.
Regards,
Pedro