WildCardFileSearch function for IBM Planning Analytics (TM1)

Where can the WildCardFileSearch function be used?

Which TM1 Server version is the WildCardFileSearch function available for?

What is the syntax for WildCardFileSearch?

• 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