Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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
hedborg
Creator
Creator

This worked for me:

Kind regards

Niklas

View solution in original post

9 Replies
hedborg
Creator
Creator

This worked for me:

Kind regards

Niklas

View solution in original post

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
Partner

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.

hedborg
Creator
Creator

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