Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
pjn123pjn123
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

What about

...

FROM 

[$(File)]

  (biff, embedded labels) 

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

View solution in original post

7 Replies
vinieme12
Champion II
Champion II

try like below

  1. let path_Alles = '[C:\XXXX\*.xls]'
  2.  
  3.  
pjn123pjn123
Contributor III
Contributor III
Author

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pjn123pjn123
Contributor III
Contributor III
Author

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
swuehl
MVP
MVP

What about

...

FROM 

[$(File)]

  (biff, embedded labels) 

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

View solution in original post

pjn123pjn123
Contributor III
Contributor III
Author

Thanks Stefan - Work like a charm!

Was almost looking for batch renaming software!

Cheers