FileList
The FileList() function returns the list of files in a directory.
Related functions: FileName, FilePath
Syntax
FileList (FilePath, Recursive search)
| FilePath | A valid file directory |
| Recursive search | When set to TRUE, a recursive search is performed on all sub folders. This parameter is optional. |
Examples
| Function | Output |
| FileList(“C:WorkMedia*.*”) | [“C:WorkMediaDraft.txt”,”C:WorkMediaDemo.PPT”,”C:WorkMediaBrochure.docx”] |
| FileList(“\MyServerSharedDrafts*.doc”) | [“\MyServerSharedDraftsInvoice01.doc”,”\MyServerSharedDraftsInvoice02.doc”] |
| FileList(“C:WorkFigures.*”) | [“C:WorkFigures.pdf”,”C:WorkFigures.xlsx”,”C:WorkFigures.csv”] |
| FileList(“C:Work*.*”,TRUE) | [“C:WorkTestResults.txt”,”C:WorkFigures.pdf”,”C:WorkFigures.xlsx”, “C:WorkFigures.csv”,”C:WorkMediaDraft.txt”,”C:WorkMediaDemo.PPT”, “C:WorkMediaBrochure.docx”] |
Note:
The file pattern must be specified, for example:
“*.*”, “*.xlsx”, “draftnumbers.*” etc.