topic Re: DirList() and FileList() in QlikView

DirList() and FileList()

Thu, 30 Jan 2014 09:20:54 GMT

Hi experts,

Can someone explain me haw these functions work and what is their syntax? I am really confused how to use them, I looked at the reference manual and I tried something like this:

For each Ext in FileList('C:\Users\Gabika\Desktop\*.x*')

Main:

LOAD

'$(vFile)' as File

AutoGenerate (1);

Whatever I tried write in bracket, the result is still: c:\Program Files\QlikView\Themes\Wind.qvt

Thank you for your answer.

Re: DirList() and FileList()

vikasmahajan — Thu, 30 Jan 2014 09:36:50 GMT

Find example from ref. manual.

// example 2 - list all QV related files on disk

sub DoDir (Root)

for each Ext in 'qvw','qvo','qvs','qvt','qvd'

for each File in filelist (Root&'\*.'&Ext)

Load '$(File)' as Name,

FileSize('$(File)') as Size,

FileTime('$(File)') as FileTime

autogenerate 1;

next File

next Ext

for each Dir in dirlist (Root&'\*')

call DoDir (Dir)

next Dir

end sub

call DoDir ('C:')

Vikas

Re: DirList() and FileList()

Thu, 30 Jan 2014 09:59:36 GMT

I looked at it, but I do not understand it. I need to explain it. Mainly I do not understand syntax in bracket.

Re: DirList() and FileList()

Anonymous — Fri, 31 Jan 2014 08:49:03 GMT

Hi,

First we define the extensions we want to look for for each Ext in 'qvw','qvo','qvs','qvt','qvd'

Then we define the directory we want to search, in this case (Root& and then we look for anything with one of the predefined extensions (see above) '\*.'&Ext)

So in this case we would search the computer for anything with these extensions 'qvw','qvo','qvs','qvt','qvd'

Re: DirList() and FileList()

Fri, 31 Jan 2014 08:56:06 GMT

What does root mean? Where is it define?

Re: DirList() and FileList()

Wed, 26 Feb 2014 20:54:44 GMT

Can someone explain me it ?

Thanks

Re: DirList() and FileList()

Clever_Anjos — Wed, 26 Feb 2014 20:56:56 GMT

Maybe this:

For each Ext in FileList('C:\Users\Gabika\Desktop\*.x*')

Main:

LOAD

'$(Ext)' as File

AutoGenerate (1);

Re: DirList() and FileList()

Thu, 27 Feb 2014 05:56:56 GMT

Root is just a parameter of such sub, which defines where your search will start from. When you invoke this sub, you use C:\ as root, which means you will search those files from C:\ and its sub-folders.

Re: DirList() and FileList()

christian77 — Thu, 31 Oct 2019 13:02:25 GMT

Hi.

My need is to read directories. I don't care a bout files this time.

Is there a DirName() function or something?

Do I have to pick up the DirName from NameFiles?

What if there is a DirName() empty?

Thanks

Re: DirList() and FileList()

Miles_Dyson — Tue, 10 May 2022 23:58:50 GMT

Does anyone know a good source to learn Looping & how to use Qlik's Listing Functions. Thanks

Re: DirList() and FileList()

MendyS — Sun, 25 Feb 2024 09:28:55 GMT

Hi
I think you missed the line -
Next Ext
regards