Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

gu0guest
New Contributor III

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

Load * Inline [

String

'Abc'

'CDE'

'[c4]'

];

1 Solution

Accepted Solutions

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

You can use another character like a double quote:

Load * Inline "

String

'Abc'

'CDE'

'[c4]'

";

5 Replies

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

You can use another character like a double quote:

Load * Inline "

String

'Abc'

'CDE'

'[c4]'

";

Not applicable

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

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

gu0guest
New Contributor III

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

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

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

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

MVP
MVP

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

Works also without the single quotes (as expected):

Load * Inline "

String

Abc

CDE

[c4]

";