Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Highlighted
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