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
- TM1User = Returns the user logged in
- WildcardFileSearch = Searches files using wildcard characters in a folder