https://community.qlik.com/t5/Talend-Studio/tExtractDelimiterFields-not-working-for-data-from-tMySqlInput/m-p/2349208#M116213 <P>Hello,</P> <P>Great this issue has been fixed by yourself. Thanks for your feedback.</P> <P>Best regards</P> <P>Sabrina</P> Fri, 01 Dec 2017 09:22:17 GMT Anonymous 2017-12-01T09:22:17Z https://community.qlik.com/t5/Talend-Studio/tExtractDelimiterFields-not-working-for-data-from-tMySqlInput/m-p/2349205#M116210 <P>i am retrieving a data from a table which has pipe "|" seperated data. I need to extract the data into different fields. I tried using&nbsp;tExtractDelimiterFields; but&nbsp;it is&nbsp;seperating&nbsp;the data per character.&nbsp;</P> <P>My data is&nbsp;<STRONG>5203011|ABC||DirectPartner|Active</STRONG></P> <P>I need it extracted by | seperation into&nbsp;</P> <P><STRONG>5203011</STRONG></P> <P><STRONG>ABC</STRONG></P> <P>&nbsp;</P> <P><STRONG>DirectPartner</STRONG></P> <P><STRONG>Active</STRONG></P> <P>&nbsp;<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="talend.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lrr8.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/158026iEB4A3FF1CB5BD5D0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lrr8.png" alt="0683p000009Lrr8.png" /></span></SPAN></P> <P>&nbsp;</P> Sat, 16 Nov 2024 09:00:06 GMT https://community.qlik.com/t5/Talend-Studio/tExtractDelimiterFields-not-working-for-data-from-tMySqlInput/m-p/2349205#M116210 Anonymous 2024-11-16T09:00:06Z https://community.qlik.com/t5/Talend-Studio/tExtractDelimiterFields-not-working-for-data-from-tMySqlInput/m-p/2349206#M116211 <P>Hello,</P> <P>Could you please post your tExtractDelimiterFields schema setting screenshot on forum?</P> <P>Best regards</P> <P>Sabrina</P> <H2 class="message-subject">&nbsp;</H2> Wed, 29 Nov 2017 09:23:41 GMT https://community.qlik.com/t5/Talend-Studio/tExtractDelimiterFields-not-working-for-data-from-tMySqlInput/m-p/2349206#M116211 Anonymous 2017-11-29T09:23:41Z https://community.qlik.com/t5/Talend-Studio/tExtractDelimiterFields-not-working-for-data-from-tMySqlInput/m-p/2349207#M116212 <P>Hi Sabrina,</P><P>I figured out the issue. Thanks.</P><P>&nbsp;</P><P>I had to use "\\|" instead of "|" as the seperator.</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 29 Nov 2017 18:59:40 GMT https://community.qlik.com/t5/Talend-Studio/tExtractDelimiterFields-not-working-for-data-from-tMySqlInput/m-p/2349207#M116212 Anonymous 2017-11-29T18:59:40Z https://community.qlik.com/t5/Talend-Studio/tExtractDelimiterFields-not-working-for-data-from-tMySqlInput/m-p/2349208#M116213 <P>Hello,</P> <P>Great this issue has been fixed by yourself. Thanks for your feedback.</P> <P>Best regards</P> <P>Sabrina</P> Fri, 01 Dec 2017 09:22:17 GMT https://community.qlik.com/t5/Talend-Studio/tExtractDelimiterFields-not-working-for-data-from-tMySqlInput/m-p/2349208#M116213 Anonymous 2017-12-01T09:22:17Z