Discussion Board for collaboration on QlikView Scripting.
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 [
Assigning the regex to a variable wouldn't be the best solution but also doesn't work:
Set v = '^[a-z]';
Go to Solution.
You can use quote characters to delimit an inline load when there is a square bracket inside the statement, like this:
LOAD * INLINE "
use in single quote.it will work
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);
Thanks Jonathan! So double quotes and square brackets can be used interchangeably?
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.