topic loading csv file with string field in QlikView https://community.qlik.com/t5/QlikView/loading-csv-file-with-string-field/m-p/345538#M127784 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In my csv file I have a field which contains some text. The problem is that there are commas within the text which interferes with the delimiter. Could anybody help me? I have provided some sample record below. The csv file does not contain any field names.</P><P></P><P>Sample.csv</P><P></P><P>1,"hi, balalal"</P><P>2,"abc,def,ghi"</P><P>3,"lala,lala,lala,lala"</P><P></P><P>Thank you for advance.</P><P></P><P>Regards,</P><P>Xue Bin</P></BODY></HTML> Thu, 10 May 2012 08:44:15 GMT 2012-05-10T08:44:15Z loading csv file with string field https://community.qlik.com/t5/QlikView/loading-csv-file-with-string-field/m-p/345538#M127784 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In my csv file I have a field which contains some text. The problem is that there are commas within the text which interferes with the delimiter. Could anybody help me? I have provided some sample record below. The csv file does not contain any field names.</P><P></P><P>Sample.csv</P><P></P><P>1,"hi, balalal"</P><P>2,"abc,def,ghi"</P><P>3,"lala,lala,lala,lala"</P><P></P><P>Thank you for advance.</P><P></P><P>Regards,</P><P>Xue Bin</P></BODY></HTML> Thu, 10 May 2012 08:44:15 GMT https://community.qlik.com/t5/QlikView/loading-csv-file-with-string-field/m-p/345538#M127784 2012-05-10T08:44:15Z loading csv file with string field https://community.qlik.com/t5/QlikView/loading-csv-file-with-string-field/m-p/345539#M127785 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Dun bother about this discussion anymore. I made a mistake. Qlikview actually handles text field with comma automatically. Something else in my code went wrong. </P><P></P><P>Regards,</P><P>Xue Bin</P></BODY></HTML> Thu, 10 May 2012 09:20:47 GMT https://community.qlik.com/t5/QlikView/loading-csv-file-with-string-field/m-p/345539#M127785 2012-05-10T09:20:47Z