Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I load inline a value that contains a QV-script-reserved character?

Hi,

I am trying to load inline, but one of the values that I want to load contains the character "]" which is QV-script-reserved. The value is:

CYCLADES]

Do you see? It contains the "]". This conflicts with the LOAD * INLINE [ ... ]; syntax.

Any clue?

Thanks in advance

Panayotis

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Read the Help for Load Inline (in the Load keyword). The answer is there

-Rob

View solution in original post

5 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi Panayotis,

You can use Excel spreadsheet as work around

Regards

Vijay

Not applicable
Author

Hmmmm. I marked your answer as helpful. I will use your advice as soon as I make sure that there is no other way to escape reserved characters somehow, when using load inline.

Thanks for your answer.

Panayotis

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Read the Help for Load Inline (in the Load keyword). The answer is there

-Rob

Not applicable
Author

Hi Rob,

Thanks for your answer.

Do you imply that I should use double quotes instead of square brackets in order to delimit my data in the load inline statement?

I suppose yes. I got it working after your comment, without having to go to EXCEL solution.

Thanks a lot.

Panayotis

P.S. Have marked your answer as correct one.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Panayotis,

Yes, double quotes was the solution I was thinking of. Glad you got it working.

-Rob