Escape parentheses

[#1]

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

[Anonymous · Accepted solution]

This worked for me:

Kind regards

Niklas

[anbu1984]

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

[martynlloyd]

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

regards,

M.

[#5]

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

[Colin-Albert]

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

[ThornOfCrowns]

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!

[#8]

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.

[Anonymous]

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

[#10]

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