topic Re: Escape parentheses in QlikView

Escape parentheses

Thu, 09 Oct 2014 15:05:36 GMT

Hi,

I have parentheses in path of my file where i need to extract the data from. QV is not accepting any parentheses in filename or the path to it. I am trying single quote to escape the parentheses but it is not working.

Is there any other way?

Saurabh

Re: Escape parentheses

Anonymous — Thu, 09 Oct 2014 15:08:12 GMT

This worked for me:

Kind regards

Niklas

Re: Escape parentheses

anbu1984 — Thu, 09 Oct 2014 15:10:02 GMT

If you keep file in the same directory where you kept your QVW, then you can remove path

Re: Escape parentheses

martynlloyd — Thu, 09 Oct 2014 15:10:29 GMT

Use [....] or "...."

regards,

Re: Escape parentheses

Thu, 09 Oct 2014 16:00:31 GMT

[] works for () and {} but it does not work if we have [] in the pathname.

Re: Escape parentheses

Colin-Albert — Thu, 09 Oct 2014 16:07:24 GMT

Can you use the ASCII codes instead and build the string using & chr(xx) &

Re: Escape parentheses

ThornOfCrowns — Thu, 09 Oct 2014 16:09:59 GMT

Have a look here for an answer:

tiqview. tmblr. com/post/30452628347/facing-square-brackets-in-field-names-of-qlikview

Remove the spaces for a valid URL!

Re: Escape parentheses

Thu, 09 Oct 2014 16:14:14 GMT

That's a great idea but the problem is I do not control the name of path...

but let me see if i can do anything on my side.

Re: Escape parentheses

Anonymous — Thu, 09 Oct 2014 17:13:12 GMT

I did some additionl testing and these worked fine:

"C:\Users\Desktop\Strange [folder]\Here is [ a strange ] document.txt"

"C:\Users\Desktop\Here is [ a strange ] document.txt"

So double quote is the alternative for [] as already suggested above.

Here is a "wild" alternative as well. Where [] has been replace with **

"C:\Users\Desktop\Here is * a strange * document.txt"

Kind regards

Niklas

Re: Escape parentheses

Thu, 09 Oct 2014 17:35:13 GMT

Hi Niklas,

The [] works when i am storing a file but it does not work when i am using this file in Load statement for QVD file.

Saurabh