Expression Mapping to delete TM and escape apostrophes

  • 12Views
  • Last Post yesterday
0
votes
Jon Christiansen posted this 2 weeks ago

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 2 weeks ago

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 2 days ago

Thank you Dmitriy, I've made the change.

0
votes
Dmitriy Muzurov posted this yesterday

Hi,

You are most welcome.

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

Close