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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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