topic Re: Square brackets in inline tables in QlikView

Square brackets in inline tables

Wed, 03 Dec 2014 08:50:45 GMT

Hi community,

is it possible to use/escape square brackets inside inline tables? I need to load regular expressions, some of which contain character classes: ^[a-z]

Double quotes don't work:

LOAD * INLINE [

name, regex

name1, "^[a-z]"

];

Assigning the regex to a variable wouldn't be the best solution but also doesn't work:

Set v = '^[a-z]';

LOAD * INLINE [

name, regex

name1, $(v)

];

Thanks,

Ivelin

Re: Square brackets in inline tables

SunilChauhan — Wed, 03 Dec 2014 08:53:24 GMT

use in single quote.it will work

LOAD * INLINE [

name, regex

name1, '^[a-z]'

];

Re: Square brackets in inline tables

jonathandienst — Wed, 03 Dec 2014 09:16:51 GMT

You can use quote characters to delimit an inline load when there is a square bracket inside the statement, like this:

LOAD * INLINE "

name, regex

name1, ^[a-z]

HTH

Jonathan

Re: Square brackets in inline tables

its_anandrjs — Wed, 03 Dec 2014 09:43:53 GMT

Hi,

You can use as ASCII characters for this also with Chr function which returns the string of given value in chr

Let vChar = Chr(94)&Chr(91)&'a-z'&Chr(93);

LOAD * INLINE [

name, rege,

name1, '$(vChar)'

];

Regards

Anand

Re: Square brackets in inline tables

Thu, 04 Dec 2014 11:42:52 GMT

Thanks Jonathan! So double quotes and square brackets can be used interchangeably?

Re: Square brackets in inline tables

kevinpintokpa — Sat, 05 Jan 2019 04:47:34 GMT

Thanks for the suggestion which does work.

However, if you click on the small hammer icon to bring up the GUI editor, it messes up the table thereafter.