Use the replace function with several strings

Question & Answer
, , , ,
1

Hello here,
Hope you’re fine!
I’d like to replace the string names of an entire column. I know that the ‘replace’ can do it.

My question is : how can I use the ‘replace’ function with several strings?
Let’s take an example:

My column contains '[1 - Paris] - [2 - Rome]. And I would like to replace them by :grinning: '[1 - France] - [2 - Italy].

How can I do for this please ?
Thank you very much !

Best,
Paul

2

Hello Paul,

can u try this ?
replace(replace(replace(column field,‘1 - Paris’,‘1 - France’),‘2 - Rome’,‘2 - Italy’),‘3 - Munich’,‘3 - Germany’)

Hope this works.
Cheers,
Deepak

2 Likes