How to use "[]" as the character in load script?

[Anonymous]

Load * Inline [

String

'Abc'

'CDE'

'[c4]'

];

[Gysbert_Wassenaar · Accepted solution]

You can use another character like a double quote:

Load * Inline "

String

'Abc'

'CDE'

'[c4]'

";

[#3]

You may use the Chr() function with the apprpriate ASCII code.

For single quote, we use Chr(39) & 'sth else" as FieldName

here, you may use it with the 91 and 93 ascii codes.

Chr(91) = [

Chr(93)= ]

Fabrice

[Anonymous]

By the way, how should I do if I have to use double quot and "[]" in load script at the same time?

[Gysbert_Wassenaar]

You can use for example ` quotes. See this blog post: Qlikview Quoteology

[rbecher]

Works also without the single quotes (as expected):

Load * Inline "

String

Abc

CDE

[c4]

";