https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256439#M38825 Ok.<BR />Then what is the use of csv options in tfileinpitdelimited.<BR /> Mon, 03 Sep 2018 10:10:07 GMT Prasanna3 2018-09-03T10:10:07Z https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256435#M38821 <P>Hi&nbsp;</P> <P>&nbsp;</P> <P>I have input file like this.</P> <P>&nbsp;</P> <TABLE border="0" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD>eno</TD> <TD>ename</TD> <TD>sal</TD> <TD>hra</TD> <TD>dno</TD> </TR> <TR> <TD>100</TD> <TD>MaHKKh</TD> <TD>1112</TD> <TD>1200</TD> <TD>10</TD> </TR> <TR> <TD>101</TD> <TD>Ma"Hesh"</TD> <TD>1007</TD> <TD>8888</TD> <TD>10</TD> </TR> <TR> <TD>102</TD> <TD>kalyan</TD> <TD>9999</TD> <TD>1000</TD> <TD>10</TD> </TR> <TR> <TD>103</TD> <TD>kal123</TD> <TD>8882</TD> <TD>1544</TD> <TD>21</TD> </TR> <TR> <TD>110</TD> <TD>Nagraj</TD> <TD>1112</TD> <TD>1000</TD> <TD>21</TD> </TR> <TR> <TD>111</TD> <TD>Nagnnn</TD> <TD>5555</TD> <TD>1004</TD> <TD>21</TD> </TR> <TR> <TD>112</TD> <TD>Nagaaa</TD> <TD>24400</TD> <TD>540</TD> <TD>21</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>how can i remove quotation marks in ename field while reading csv file?</P> Sat, 16 Nov 2024 07:43:51 GMT https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256435#M38821 Prasanna3 2024-11-16T07:43:51Z https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256436#M38822 <P>Hi&nbsp;<A href="https://community.qlik.com/s/profile/0053p000007LOiPAAW">@prasan</A>,</P> <P>Have u tried Replace functions in tmap expression editor?</P> Mon, 03 Sep 2018 07:27:47 GMT https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256436#M38822 abhi90 2018-09-03T07:27:47Z https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256437#M38823 <P>No i didn't try with tmap,</P> <P>&nbsp;</P> <P>i am reading csv file by using tfileinputdelimited how can i set escape char or text enclosure in advanced settings.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture10.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzmM.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150820iD0ADEAD90D7A158B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LzmM.png" alt="0683p000009LzmM.png" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 03 Sep 2018 07:34:01 GMT https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256437#M38823 Prasanna3 2018-09-03T07:34:01Z https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256438#M38824 <P>Hi&nbsp;<A href="https://community.qlik.com/s/profile/0053p000007LOiPAAW">@prasan</A>,</P> <P>You can try with treplace also. in tReplace name the Column,In the search for Keep """ and keep nothing in to be replaced column and try</P> Mon, 03 Sep 2018 09:40:45 GMT https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256438#M38824 abhi90 2018-09-03T09:40:45Z https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256439#M38825 Ok.<BR />Then what is the use of csv options in tfileinpitdelimited.<BR /> Mon, 03 Sep 2018 10:10:07 GMT https://community.qlik.com/t5/Talend-Studio/Scenario-based-Question-in-Talend/m-p/2256439#M38825 Prasanna3 2018-09-03T10:10:07Z