ExtractString

Extracts string fragment using regular expression.

Syntax

 ExtractString(String_Expression, regular_expression, group)

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.

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