Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Read the Help for Load Inline (in the Load keyword). The answer is there
-Rob
Hi Panayotis,
You can use Excel spreadsheet as work around
Regards
Vijay
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
Read the Help for Load Inline (in the Load keyword). The answer is there
-Rob
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.
Panayotis,
Yes, double quotes was the solution I was thinking of. Glad you got it working.
-Rob