Products | Versions |
---|---|
Spotfire Statistica | 13.3.1 and later |
Statistica provides a broad selection of regular expression functions that can be used in spreadsheet formulas like all other functions. Regular expression functions provide the ability to search and replace text using fuzzy matching.
The list of available regular expression functions include RE_SEARCH, RE_MATCH, RE_REPLACE and LIKE.
Attached document "StatisticaRegularExpressionFunctions.pdf" introduce the parameters, options these functions take and the results they return.
For example, RE_MATCH function takes input parameters (input_exp, reg_exp, options), and returns true if input_expr matches the regular expression reg_exp.
Attached document "StatisticaRegularExpressionSyntaxes.pdf" shows and explains the syntax of the regular expression string (reg_exp).
For example, "\d{6}" represents a pattern of consecutive 6 digits with each coming from 0 to 9.
Attached document "StatisticaRegularExpressionExamples.pdf" gives a set of regular expression matching examples.
For example, =RE_MATCH(VarName, "EXP\d{2}-\d{6}-COL-\d{3}", "i") will return true for a VarName value like "EXP12-123456-COL-123".
User can also find the same documents in Statistica e-manual.
Go to Statistica e-manual (https://support.tibco.com/s/article/How-to-access-Statistica-e-manual), and search the keyword "Regular Expression" in the searching textbox.