Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe using single quotes?
Hope this helps,
Stefan
and double quotes ( " ) works also
Thanks! So simple.
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 ';');
Puttin the ENTIRE string (not only the comma) in single quotes worked fine for me! thanks
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.
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.