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

[#1]

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

[vijay_iitkgp]

Hi Panayotis,

You can use Excel spreadsheet as work around

Regards

Vijay

[#3]

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 · Accepted solution]

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

-Rob

[#5]

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]

Panayotis,

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

-Rob