All eazyBI for Jira eazyBI for Confluence Private eazyBI

ExtractString

EAZYBI Extracts a fragment of string using regular expression.

Syntax

 ExtractString(String_Expression, Regular_Expression, Numeric_Expression)

Arguments

String_ExpressionMDX expression that returns a string that should be parsed using regular expression.
Regular_ExpressionRegular expression string that should be used to parse the string.
Numeric_ExpressionAn integer value of the matched regular expression group (in parenthesis) that should be returned. If no group is specified, then all matched strings will be returned.

Examples

The following example will return '2' :

ExtractString('Estimate:5h. Left:2h.', '.*Left:(\d+).*', 1)

It uses a regular expression which will match Left: followed by one or more digits and will return this first matched group which is (\d+).

The formula below will extract a number of the sprint if the sprint name contains this pattern Sprint <number>, for example, Sprint 30, D1 Sprint 30, etc. The sprint number is transferred to numeric with function Val and used in comparison to the value 30.

Val(ExtractString([Sprint].CurrentMember.Name, '.*Sprint (\d+)', 1)) >=30

See sample report Sprint gantt chart in our Demo account. The report has a sprint calculated member  Sprints 30+ as a selection on Pages. The calculated member Sprints 30+ uses the formula above as a part of the calculation to identify sprints with number >= 30 that could be used as a sprint selection on Pages.

See also