https://community.qlik.com/t5/Talend-Studio/Escape-char-and-text-enclosure-functionality/m-p/2369945#M133045 <P>Any one please guide here​</P> Tue, 05 Oct 2021 06:35:48 GMT Banupriya 2021-10-05T06:35:48Z https://community.qlik.com/t5/Talend-Studio/Escape-char-and-text-enclosure-functionality/m-p/2369944#M133044 <P>Hi All, </P><P>​</P><P>​</P><P></P><P>Our requirment is to process a, ",|" (Pipe) delimited file having, "|" (Pipe) enclosed within double quotes for some of the fields. We need to ignore the pipe that enclosed with in double quotes while processing. </P><P>​</P><P>We tried implementing CSV option enabled with escape char : ,"\|"​ and Text enclosure : """, but it did not work as expected. </P><P>​</P><P>We need a same output as input with out any modification for one of our requirment.</P><P>​</P><P>Example</P><P>INPUT</P><P>​</P><P>Col1|Col2|Col3|Col4</P><P>123|BE|," Ram|kumar"|24</P><P>​</P><P>Expected output</P><P>Col1|Col2|Col3|Col4</P><P>123|BE|," Ram|kumar"|24</P><P>​</P><P>​</P><P>Please need your suggestion. </P><P>​</P><P>​</P><P>Thankyou</P><P>​</P> Fri, 15 Nov 2024 23:39:57 GMT https://community.qlik.com/t5/Talend-Studio/Escape-char-and-text-enclosure-functionality/m-p/2369944#M133044 Banupriya 2024-11-15T23:39:57Z https://community.qlik.com/t5/Talend-Studio/Escape-char-and-text-enclosure-functionality/m-p/2369945#M133045 <P>Any one please guide here​</P> Tue, 05 Oct 2021 06:35:48 GMT https://community.qlik.com/t5/Talend-Studio/Escape-char-and-text-enclosure-functionality/m-p/2369945#M133045 Banupriya 2021-10-05T06:35:48Z