topic Re: escape character? in QlikView

escape character?

Wed, 28 Sep 2011 11:47:01 GMT

hi...

am pretty new to QV.

problem below...

LOAD abc,

xyz,

abcd

FROM

**url is not real

my query above is a url(kdb). The query itself has a '[]', which seems to be interfering with the '[]' from the load statement.

whats the work around?

Thanks a lot.

rwunderlich — Wed, 28 Sep 2011 14:34:26 GMT

Try using " " (double quotes) around the url instead of [].

['http://asdasds.pp.nnn.net:2334/.txt?....' & chr(91) & chr(93) & '........']

-Rob

Fri, 07 Oct 2011 06:09:53 GMT

Thanks for the response, but I already tried both single and double quotes...
i found a way around...not a qv option though...

in this sql, 'if' statement is represented by '['...so i just removed the if condition and wrote the sql twice,

once each for the conditions that were in the if loop...n put the if in where