Replace " within component tMysqlInput

Anonymous — Fri, 05 Oct 2018 10:02:30 GMT

Trying to replace the character " with nothing gives and error when trying to build the job.

This is of course because the " is used by talend itself.

My simple query is : "SELECT id, replace(postal_code,'"','') as postal_code from table"

Is there any other way I can replace the character " that is in the data field postal_code using talend?

regards,

Tomas

Re: Replace " within component tMysqlInput

vapukov — Fri, 05 Oct 2018 10:35:39 GMT

just use escape character

"SELECT id, replace(postal_code,'\"','') as postal_code from table"

same possible todo in tMap