...
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