Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Bharath12
Contributor III
Contributor III

getting back slashes from twritejsonfiled component

 

Hi All

 

how to eliminate backslashes from twritejson field. Can some one help me with that

 

\"company\":{\"empid\":\"10000\",\"fullName\":\"Caste, Yan \",\"knownAs\":\"YAN\",\"employeeType\":\"Employee\",\"hrManager\":{\"empid":\"2125\",\"name\":\"PE, VERO MARIE\"},\"industryGroup\":\"Healthcare\",\"jobFunction\":\"Engineering\/Technology\",\"bus

 

Can you please help me how to eliminate backslashes.

 

Thanks,

Labels (4)
1 Reply
Anonymous
Not applicable

Hi,

 

    Could you please add the following function in tMap as shown below?

 

row1.data.replace("\\","")

0683p000009M3Mw.png

 

Output will be as shown below.

 

"company":{"empid":"10000","fullName":"Caste, Yan ","knownAs":"YAN","employeeType":"Employee","hrManager":{"empid":"2125","name":"PE, VERO MARIE"},"industryGroup":"Healthcare","jobFunction":"Engineering/Technology","bus

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂