List of files in a folder

[#1]

Hi there

Is it possible to generate a list ex. in a straight table of files from a folder/subfolder on the drive?
If so how can i make this list?

Thanks

/Teis

[martinpohl]

here the scipt:

for each file in filelist('C:\Temp\*.*')

first 1 load

filename() as File

from '$(file)';

next

Regards

[#3]

       sub ScanFolder(Root)

          for each FileExtension in '*'

                    for each FoundFile in filelist( Root & '\*.' & FileExtension)

                              FileList:

                              LOAD '$(FoundFile)' as Name,

                              Filesize('$(FoundFile)') as Size,

                              QvdNoOfRecords ('$(FoundFile)') as NoOfRecords,

                              Filetime('$(FoundFile)') as Time

       AUTOGENERATE 1;

                    next FoundFile

          next FileExtension

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

                    call ScanFolder(SubDirectory)

          next SubDirectory

end sub

Call ScanFolder('D:\Qlik Path Name') ;

Replace the Path in the Call function to your install - the output of this will give you a straight table using these dimensions:

Name

Time

Size

NoOfRecords

[maxgro]

load

  FileName(),

  1

from 'c:\temp\*.*';

[ashfaq_haseeb · Accepted solution]

Yes possible,

have a look at attached zip files.

Regards

ASHFAQ

[Andrea_Ghirardello]

Try this suggestion:

How to use regular expressions

Hope this helps.

Andrea