Loading file with a "(" or ")" in its file name - Error

[pjn123pjn123]

My script is loading all the xls files in a folder but I get the following error as soon as one of these files have a "(" or ")" in the filename:

"File Not Found".

Am I doing something wrong or is this a limitation of QlikView?

Thanks in advance!

let path_Alles = 'C:\XXXX\*.xls';


for each File in filelist (path_Alles)


AllData:
LOAD SubField('#'&Replace([Policy No],' ',''),'.',1) as Policy, 
     Insured as Client,
     'YYYY' as Provider  
FROM
  $(File)
  (biff, embedded labels)
  Where Len(Trim([Policy No])) > 2;



next File

[vinieme12]

try like below

1. let path_Alles = '[C:\XXXX\*.xls]'; 
2.  
3.  

[pjn123pjn123]

Hi Veneeth

Thanks for the reply.

Unfortunately, if I change that line nothing gets loaded (loads of errors). 

[Anil_Babu_Samineni]

May be change as SET instead of LET

[pjn123pjn123]

Hi Anil

Tried it with a SET with and without the [ ] but I get the same result as before.

[Anil_Babu_Samineni]

Can you show the image for $(File) in text object

[swuehl · Accepted solution]

What about

...

FROM 

[$(File)]

  (biff, embedded labels) 

  Where Len(Trim([Policy No])) > 2; 

[pjn123pjn123]

Thanks Stefan - Work like a charm!

Was almost looking for batch renaming software!

Cheers