Cognos Data Manager FileList Function

Cognos Data Manager FileList Function

CognosDataManagerFileListFunction

Function:FileList

Category:Control

Syntax:FileList('Folder_Path\Search_Criteria'[,ReturnFullPath,SearchSubDirectory]);

Explanation:FileListfunctionisusedtosearchfilesinafolder.Itreturnsacommaseparatedlistoffilename.Booleanoptionsisalsoavailabletoincludefullfilepathandsearchinsubdirectory.

Example:

FileList('C:\TestFolde\*')Itreturnsalltheavailablefilesinthegivenfolder.

FileList('C:\TestFolde\*.csv')Itreturnsalltheavailablecsvfilesinthegivenfolder.

FileList('C:\TestFolde\*.csv',TRUE)Itreturnsalltheavailablecsvfilesinthegivenfolderwithfullpath.

FileList('C:\TestFolde\*.xls',TRUE,TRUE)ItreturnsalltheavailableExcelfilesinthegivenfolderandSubFolderwithfullpath.

FileList('C:\TestFolde\*.txt',FALSE,TRUE)ItreturnsalltheavailableTextfilesinthegivenfolderandSubFolder.

Usage:Itwillusetofindouttheavailabilityoffileinagivenfolder.

Yourcommentswillbehighlyappreciated.

0 Comments
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first

share