https://community.qlik.com/t5/Talend-Studio/getting-back-slashes-from-twritejsonfiled-component/m-p/2244044#M30329 <P>Hi,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; Could you please add the following function in tMap as shown below?</P> <P>&nbsp;</P> <PRE>row1.data.replace("\\","")</PRE> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M3Mw.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150728iB1EB9CE774DF2047/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M3Mw.png" alt="0683p000009M3Mw.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Output will be as shown below.</P> <P>&nbsp;</P> <PRE>"company":{"empid":"10000","fullName":"Caste, Yan ","knownAs":"YAN","employeeType":"Employee","hrManager":{"empid":"2125","name":"PE, VERO MARIE"},"industryGroup":"Healthcare","jobFunction":"Engineering/Technology","bus</PRE> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 12 Mar 2019 00:55:32 GMT Anonymous 2019-03-12T00:55:32Z https://community.qlik.com/t5/Talend-Studio/getting-back-slashes-from-twritejsonfiled-component/m-p/2244043#M30328 <DIV class="lia-note-subject lia-component-subject">&nbsp;</DIV><DIV class="lia-note-body lia-component-body"><P>Hi All</P><P>&nbsp;</P><P>how to eliminate backslashes from twritejson field. Can some one help me with that</P><P>&nbsp;</P><P>\"company\":{\"empid\":\"10000\",\"fullName\":\"Caste, Yan \",\"knownAs\":\"YAN\",\"employeeType\":\"Employee\",\"hrManager\":{\"empid":\"2125\",\"name\":\"PE, VERO MARIE\"},\"industryGroup\":\"Healthcare\",\"jobFunction\":\"Engineering\/Technology\",\"bus</P><P>&nbsp;</P><P>Can you please help me how to eliminate backslashes.</P><P>&nbsp;</P><P>Thanks,</P></DIV> Sat, 16 Nov 2024 06:22:01 GMT https://community.qlik.com/t5/Talend-Studio/getting-back-slashes-from-twritejsonfiled-component/m-p/2244043#M30328 Bharath12 2024-11-16T06:22:01Z https://community.qlik.com/t5/Talend-Studio/getting-back-slashes-from-twritejsonfiled-component/m-p/2244044#M30329 <P>Hi,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; Could you please add the following function in tMap as shown below?</P> <P>&nbsp;</P> <PRE>row1.data.replace("\\","")</PRE> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M3Mw.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150728iB1EB9CE774DF2047/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M3Mw.png" alt="0683p000009M3Mw.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Output will be as shown below.</P> <P>&nbsp;</P> <PRE>"company":{"empid":"10000","fullName":"Caste, Yan ","knownAs":"YAN","employeeType":"Employee","hrManager":{"empid":"2125","name":"PE, VERO MARIE"},"industryGroup":"Healthcare","jobFunction":"Engineering/Technology","bus</PRE> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 12 Mar 2019 00:55:32 GMT https://community.qlik.com/t5/Talend-Studio/getting-back-slashes-from-twritejsonfiled-component/m-p/2244044#M30329 Anonymous 2019-03-12T00:55:32Z