Inline load with commas

[#1]

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

[swuehl · Accepted solution]

Maybe using single quotes?

Hope this helps,

Stefan

[gandalfgray]

and double quotes ( " ) works also

[#4]

Thanks!  So simple.

[#5]

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 ';');

[nigel987]

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

[jertindall]

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.

[nate_muir_anderson]

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

[Christos_Nikolis]

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.