Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This worked for me:
Kind regards
Niklas
If you keep file in the same directory where you kept your QVW, then you can remove path
Use [....] or "...."
regards,
M.
[] works for () and {} but it does not work if we have [] in the pathname.
Can you use the ASCII codes instead and build the string using & chr(xx) &
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!
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.
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
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