Extracts string fragment using regular expression.
Syntax
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+).