https://community.qlik.com/t5/Data-Quality/exporting-the-data-from-csv-file-to-database-table/m-p/2265961#M2120 <P>Have you tried playing with CSV options in tfileinputDelimited ?</P><P>By clicking that option it may allow you to select "TEXT Enclosure" in which you can mention " as text enclosure.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 04 Dec 2019 21:05:28 GMT talend777 2019-12-04T21:05:28Z https://community.qlik.com/t5/Data-Quality/exporting-the-data-from-csv-file-to-database-table/m-p/2265960#M2119 <P>hi guys, I need a help in exporting the data from a .csv file to database table. my csv file first row has below format:&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.PNG" style="width: 653px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8dr.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136335i1D04A15A2673A217/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8dr.png" alt="0683p000009M8dr.png" /></span></SPAN></P> <P>I would like to export the data into table in below format. And how can I remove quotes around the strings.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 364px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8c6.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131957i0C7EC21E4AD99F9B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8c6.png" alt="0683p000009M8c6.png" /></span></SPAN></P> Sat, 16 Nov 2024 03:55:26 GMT https://community.qlik.com/t5/Data-Quality/exporting-the-data-from-csv-file-to-database-table/m-p/2265960#M2119 Anonymous 2024-11-16T03:55:26Z https://community.qlik.com/t5/Data-Quality/exporting-the-data-from-csv-file-to-database-table/m-p/2265961#M2120 <P>Have you tried playing with CSV options in tfileinputDelimited ?</P><P>By clicking that option it may allow you to select "TEXT Enclosure" in which you can mention " as text enclosure.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 04 Dec 2019 21:05:28 GMT https://community.qlik.com/t5/Data-Quality/exporting-the-data-from-csv-file-to-database-table/m-p/2265961#M2120 talend777 2019-12-04T21:05:28Z