topic Re: Inline load with commas in QlikView

Inline load with commas

Tue, 06 Sep 2011 09:37:39 GMT

Hi Everyone,

I often need to load small inline tables, some that contain commas.

Example:

ID, Phrase

1, Hello

2, Hello, how are you?

3, Hello, today you look happy

Obviously when I load I get truncated data for Phrase for ID's 2 & 3 due to the comma as QV thinks it is a separater for the next column. I have tried putting the phrases inside square brackets, but QV doesn't like these for the inline load as it takes the ']' as being a closing statement for the inline load.

How do I get around this?

Thanks

Gareth

Inline load with commas

swuehl — Tue, 06 Sep 2011 09:40:14 GMT

Maybe using single quotes?

Hope this helps,

Stefan

Inline load with commas

gandalfgray — Tue, 06 Sep 2011 09:46:58 GMT

and double quotes ( " ) works also

Inline load with commas

Tue, 06 Sep 2011 09:53:40 GMT

Thanks! So simple.

Re: Inline load with commas

Mon, 25 Nov 2013 19:39:25 GMT

Hi Gareth,

You can user as under (delimiter is ';');

LOAD * Inline

[ ID; Phrase

1; Hello

2; Hello, how are you?

3; Hello, today you look happy

](delimiter is ';');

Re: Inline load with commas

nigel987 — Fri, 07 Aug 2015 09:24:25 GMT

Puttin the ENTIRE string (not only the comma) in single quotes worked fine for me! thanks

Re: Inline load with commas

jertindall — Fri, 18 Sep 2015 17:47:35 GMT

Thank you Devang for the delimiter hint. Single quotes did not do the trick for me, but changing the delimiter was exactly what I needed.

Re: Inline load with commas

nate_muir_anderson — Tue, 11 Dec 2018 17:46:33 GMT

Also works when delimiters are tabs :
(delimiter is ' ');

Re: Inline load with commas

Christos_Nikolis — Tue, 20 Jun 2023 13:21:52 GMT

Enclosing the whole string in double quotes worked for me, like:

" the blaah, of the di-blaaah's "

It effectively showed all the commas, plus single quotes (for example in : 's )

Single quotes didn't do the trick. Using Qlik Sense enterprise at the time of writing.