Support center for flex.bi version 3.2

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

  • No labels