Replace " within component tMysqlInput

[Anonymous]

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

[vapukov · Accepted solution]

just use escape character

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

same possible todo in tMap