topic Re: Weird issue with filelist function + wildcard + CSV files in QlikView

Weird issue with filelist function + wildcard + CSV files

Thu, 11 Dec 2014 14:01:48 GMT

Hi !

I am using the filelist() function along with a "for each" in order to load several CSV files. I am using QV 11.20.

This particular piece of code :

For each vFile in FileList('.\*.csv')
trace file : $(vFile);
sleep 2000;
Next vFile

leads to load *.csv file which is the expected behavior, but it also loads *.csv*. It means it loads also *.csv_old for example.

I tried also with xlsx files, but it behaves correctly in that case. This seems specific to CSV files.

Is there any mean to disable this strange behavior ?

Thanks,

Laurent

marcus_sommer — Thu, 11 Dec 2014 15:02:12 GMT

It looks like a bug .... You could as workaround check the extension directly or the len(extension) in an additionally step like:

if subfield('$(vFile)', '.', -1) = 'csv' then

...

end if

- Marcus

Thu, 11 Dec 2014 15:55:31 GMT

Thanks Marcus.

Actually, we used a similar code to bypass this bug :

if('$(vFile)' like '*.csv') then

...

end if

Laurent

pljsoftware — Fri, 12 Dec 2014 15:18:47 GMT

Hi Laurent,

this is a bug, reports to Qlikview.

Thanks for your note.

Luca Jonathan Panetta

Anonymous — Fri, 12 Dec 2014 16:41:06 GMT

Yes. It's a bug.

Test the filename extension individually inside loop.

Caria