Syntax & Examples for Statistica Regular Expression Functions

Syntax & Examples for Statistica Regular Expression Functions

book

Article ID: KB0075600

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.3.1 and later

Description

This article provides documents on the syntax and examples of Statistica Regular Expression Functions.

Issue/Introduction

Syntax & Examples for Statistica Regular Expression Functions

Environment

Winodws

Resolution

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.

Attachments

Syntax & Examples for Statistica Regular Expression Functions get_app
Syntax & Examples for Statistica Regular Expression Functions get_app
Syntax & Examples for Statistica Regular Expression Functions get_app