Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

loading csv file with string field

Hi,

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.

Sample.csv

1,"hi, balalal"

2,"abc,def,ghi"

3,"lala,lala,lala,lala"

Thank you for advance.

Regards,

Xue Bin

1 Reply
Not applicable
Author

Hi all,

     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.

Regards,

Xue Bin