Expression Mapping to delete TM and escape apostrophes

  • 47Views
  • Last Post 16 August 2019
0
votes
Jon Christiansen posted this 07 August 2019

Hi,

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, 

Elisa

Order By: Standard | Newest | Votes
0
votes
Dmitriy Muzurov posted this 08 August 2019

Hi Elisa,

Thank you for submitting a ticket with us.

We checked your package and found this error message:

"invalid byte sequence for encoding "UTF8": 0xae"

Please select Unicode check box in the Advanced Parameters of your PostgreSQL connection.

This option should help with importing special characters to PostgreSQL.

We are looking forward to hearing from you, should you require any further assistance.

0
votes
Jon Christiansen posted this 15 August 2019

Thank you Dmitriy, I've made the change.

0
votes
Dmitriy Muzurov posted this 16 August 2019

Hi,

You are most welcome.

Should you have any questions, do not hesitate to contact us back.

Close