topic tFileOutputJSON inserting inserting "/" characters in Talend Studio

tFileOutputJSON inserting inserting "/" characters

Anonymous — Sat, 16 Nov 2024 02:21:03 GMT

Hello Guys,

I have simple job to convert csv file to JSON. when the data has / as part of the value, the json file is getting created with additional \ in the file. example is below.

tFileInputDelimiter -> tFileOutputJSON

input : /data/policy

output: \/data\/policy

However in tLogrow it shows the output without \.

Re: tFileOutputJSON inserting inserting "/" characters

TRF — Sat, 23 May 2020 10:14:37 GMT

\ is the escape character to protect special characters such as /. Of course it's not really part of data and displayed within tLogRow and others.
So, what's the question?

Re: tFileOutputJSON inserting inserting "/" characters

Anonymous — Sun, 24 May 2020 02:10:32 GMT

@TRF - Thanks for the reply.

How can we avoid the \ escape character in the created JSON file. Is this possible do we have other workaroun.