WildCardFileSearch function for IBM Planning Analytics (TM1)
WildCardFileSearch searches files using wildcard characters in a folder.
In this video, WildCardFileSearch is used to search files starting with a P.
Where can the WildCardFileSearch function be used?
TurboIntegrator
Which TM1 Server version is the WildCardFileSearch function available for?
Version 11 and 12
What is the syntax for WildCardFileSearch?
WildCardFileSearch(Pathname, PriorFilename)
Pathname = A file path including file search criteria that can contain a wildcard character. (eg: C:WildcardFileSearchP*)
PriorFilename = Name of the existing file in the folder. If we pass an empty string argument, then the function returns the first file that matches the criteria
Relevant Functions
AddInfoCubeRestriction = Filters InfoCube data as it is pulled into TM1. Use this function to restrict the values that are imported for a specified characteristic
Expand = Expands variable names, enclosed in % signs
FileExists = Searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned
LogOutput = Writes a message to the tm1server.log file
