Use the replace function with several strings

Question & Answer
, , , ,
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