Four Stars

Replace special character with ASCII values in Jason

Hi Team,

 

please help me with below issue.

I have a talend job Connecting to Oracle as a source then usinng  tmap writing data into Json file.

now issues is when ever special characters are coming in 3 columns and job is failed not able to handle special characters.

how to replace the any special characters with equivalent ASCII value then write into JSON file.

 

Please provide your inputs.

Thanks in advance.

 

 

1 REPLY
Moderator

Re: Replace special character with ASCII values in Jason

Hello,

Take a look at tReplaceList component, this component allows you to replace special characters for multiple columns at a time. 

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.