ExtractString
Extracts string fragment using regular expression.
Syntax
CODE
ExtractString(String_Expression, regular_expression, group)Arguments
| String_Expression | MDX expression that returns string which should be parsed using regular expression. |
|---|---|
| regular_expression | Regular expression string that should be used to parse string. |
| group | Matched 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+).