...
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+).
See also
Regular expressionsexpression