topic Load inline with ] inside the data in QlikView

Load inline with ] inside the data

hrolofs — Tue, 24 Jul 2012 09:32:48 GMT

Hello,

how i can use the ] character inside the data?

LOAD * INLINE [

F1, F2

test, "[test]"

];

Regards, Henry

Re: Load inline with ] inside the data

Miguel_Angel_Baeyens — Tue, 24 Jul 2012 09:48:11 GMT

Hi Henry,

Try something like this:

Data:
LOAD F1, Replace(Replace(F2, '$<', '['), '>$', ']') AS F2 INLINE [
F1, F2
test, $<test>$
];

Yes, that means that you have to change the source characters, but it shouldn't be an issue since it's an INLINE (therefore hardcoded) table.

Hope that helps.

Miguel

Re: Load inline with ] inside the data

hrolofs — Tue, 24 Jul 2012 09:58:19 GMT

Hello Miguel,

thanks for your answer.

After i try to esacpe the ] character without success I found an other easy way:

LOAD * INLINE "

F1, F2

test, '[test]'

inline is used if data should be typed within the script, and not loaded from a file. Use the Inline Data Wizard for help with the creation of load inline statements.

data ::= [ text ]

Data entered through an inline clause must be enclosed by quotation marks or with square brackets. The text between these is interpreted in the same way as the content of a file. Hence, where you would insert a new line in a text file, you should also do it in the text of an inline clause, i.e. by pressing the <ENTER> key when typing the script.

Quotation marks

If quotation marks are possible or necessary within a statement, it is mentioned below. In a load statement the following symbols should be used as quotation marks:

Field names:	[ ] , " " , ` ` or ´ ´
String literals:	' '

Re: Load inline with ] inside the data

Miguel_Angel_Baeyens — Tue, 24 Jul 2012 10:02:04 GMT

Yep,

That one is far easier!

Miguel

Re: Load inline with ] inside the data

Tue, 23 Oct 2012 23:50:48 GMT

What is the format to use when the inline data contains an apostrophe? Neither doubling the single quote nor adding a preceding backslash worked for me.