Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

escape character?

hi...

am pretty new to QV.

problem below...

LOAD abc,

          xyz,

          abcd

FROM

[http://asdasds.pp.nnn.net:2334/.txt?....[]........]

**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.

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Or

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

-Rob

Not applicable
Author

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