Document toolboxDocument toolbox

ExtractString

Extracts string fragment using regular expression.

Syntax

ExtractString(String_Expression, regular_expression, group)

Arguments

String_ExpressionMDX expression that returns string which should be parsed using regular expression.
regular_expressionRegular expression string that should be used to parse string.
groupMatched regular expression group (in parenthesis) that should be returned. If no group is specified then all matched string will be returned.

Examples

ExtractString('Estimate:5h. Left:2h.', '.*Left:(\d+).*', 1) will return '2' 

It uses regular expression which will match Left: followed by one or more digits and will return this first matched group which is (\d+).

See also

Regular expressions