Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Escape parentheses

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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
hedborg
Contributor

Re: Escape parentheses

This worked for me:

Kind regards

Niklas

9 Replies
Highlighted
hedborg
Contributor

Re: Escape parentheses

This worked for me:

Kind regards

Niklas

anbu1984
Honored Contributor III

Re: Escape parentheses

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

Partner
Partner

Re: Escape parentheses

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

regards,

M.

Not applicable

Re: Escape parentheses

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

Re: Escape parentheses

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

thornofcrowns
Valued Contributor II

Re: Escape parentheses

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!

Not applicable

Re: Escape parentheses

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.

hedborg
Contributor

Re: Escape parentheses

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

Not applicable

Re: Escape parentheses

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