Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
selracir
New Contributor

Data loading - quoting and delimiter issue

I have a dataset that it is split by a pipe delimeter (¦) and in some cases the string has quotations.

I have tried the select data with quoting none and the quotations appear in the fields 

quoting.JPG

If I try it with standard the quotes don't appear, but the split does not work. It adds the full row (within quotes) in the first field

 

standard.JPG

Any ideas on how I can split it out correctly?

Tags (2)
2 Replies
dwforest
Valued Contributor

Re: Data loading - quoting and delimiter issue

Since the split is correct using None, try using Replace() to get rid of the quotes.
Replace(@1,'"','')
selracir
New Contributor

Re: Data loading - quoting and delimiter issue

Perfect, thanks