Mapping fields and replacing the strings

Question

Hi Team,

Hope you are well. I need help.

I have the input file and the mapping file.

I would like to replace the string in all the columns of the "alt_input_new" file with the "Replaced value" column in the mapping file.

For e.g. Taiwan(china) in the SOS file should be replaced with "Taiwan".

Can you please help?

Thanks

Sri

alt_input_new.xlsx

alt_map_new.xlsx

sriniprad08 · Answer

Hi @IraWatt ,

Thank you for the kind help.

Cheers,

Sri

sriniprad08 · Answer

Hi @AngelosPachis ,

Thank you for the kind help.

Cheers,

Sr

sriniprad08 · Answer

Hi @gabrielvilella ,

Thank you so much for the kind reply. Really appreciate it. May be i was not clear in my request.

Actually based on the below table where it finds Taiwan it has to be replaced with "Taiwan". For eg. Below SOS has "Taiwan(China)" it has to be replaced with "Taiwan". Ideally all the three columns should have the same value to perform a join later.