Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

This worked for me:

Kind regards

Niklas

View solution in original post

9 Replies
Anonymous
Not applicable
Author

This worked for me:

Kind regards

Niklas

anbu1984
Master III
Master III

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

martynlloyd
Partner - Creator III
Partner - Creator III

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

regards,

M.

Not applicable
Author

[] 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
Specialist II
Specialist II

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
Author

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
Not applicable
Author

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
Author

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