I'm trying to map an import from a google drive csv to a postgres table. Currently, I clean up the data during the skyvia process by using expression mapping to delete trademark symbols before the data goes to postgres with REPLACE([EXHIBITOR NAME],"™","") and that works.
Now, I also need to escape apostrophes in the data so it goes to postgres correctly, eg. if the Exhibitor Name is L'aise it won't import, but I figure like usual if I replace apostrophes with double apostrophes, eg. replace L'aise with L''aise, then postgres will correctly escape the apostrophe upon import.
I've tried to do REPLACE(REPLACE([EXHIBITOR NAME],"™",""),"'","''") and REPLACE(REPLACE([EXHIBITOR NAME],"'","''"),"™","") and neither of those work. Is there a way to perform multiple functions in expression mapping at once?
Thanks in advance,