topic Re: Looping over Filelist() with wierd symbols in filenames in QlikView

Looping over Filelist() with wierd symbols in filenames

mantaq10 — Sun, 14 Oct 2012 10:42:50 GMT

Hi all,

I have a folder with lots of xml files, each having names with whitespaces and special characters. e.g. c:\my file is wierd (strange, obnoxious, wow).xml

I am trying to run this snippet but am not able to parse files with symbols like brackets '('. How do I enforce [ ] escaping within a filelist() call? I've tried putting [ ] in both places but in vain...

let vFilePath = 'C:\Users\Atif\Desktop\KM PMO\Discovery\DataSource\Closure Document\*.xml';

for each File in filelist (vFilePath)

Load *

from $(File);

next File

Much Appreciated

A Business User

Atif

Re: Looping over Filelist() with wierd symbols in filenames

IAMDV — Sun, 14 Oct 2012 10:52:22 GMT

Atif,

Please can you provide the sample file? It'll be easy to work with the actual file.

Thanks,

www.QlikShare.com

Re: Looping over Filelist() with wierd symbols in filenames

mantaq10 — Sun, 14 Oct 2012 11:02:27 GMT

Thanks Deepak for the quick response.

Here you go.

Right now, the parser churns out the string part starting from '('.

For other files, ',' is the culprit. Since there are 100's of files, i want to somehow incoporate a generic solution like an escape character, am plucking the last set of hair strands

Re: Looping over Filelist() with wierd symbols in filenames

kaushiknsolanki — Sun, 14 Oct 2012 15:17:39 GMT

Its working properly.

Have a look at the example attched.

Only change the Root path.

Regards,

Kaushik Solanki

Re: Looping over Filelist() with wierd symbols in filenames

mantaq10 — Sun, 14 Oct 2012 15:46:52 GMT

Thanks Kaushik,

However I got it solved with a similar code snippet...Appreciate your response.

let vFilePath = 'C:\Users\Atif\Desktop\KM PMO\Discovery\DataSource\Closure Document\';

for each File in filelist ('$(vFilePath)*.xml')

LOAD *

, filename() as Project_Name3

from [$(File)] (XmlSimple, Table is [myFields]) ;

next File