Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

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

-Rob

5 Replies
vijay_iitkgp
Valued Contributor

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

Hi Panayotis,

You can use Excel spreadsheet as work around

Regards

Vijay

Not applicable

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

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

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

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

-Rob

Not applicable

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

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.

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

Panayotis,

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

-Rob

Community Browser