tFileOutputJSON inserting inserting "/" characters

Highlighted
Six Stars

tFileOutputJSON inserting inserting "/" characters

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 \.

Sixteen Stars
Sixteen Stars

Re: tFileOutputJSON inserting inserting "/" characters

\ 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?

TRF
Highlighted
Six Stars

Re: tFileOutputJSON inserting inserting "/" characters

@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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog