# \#regex **URL:** https://community.eazybi.com/tag/regex/106.md [Latest](https://community.eazybi.com/latest.md) · [Categories](https://community.eazybi.com/categories.md) · [Tags](https://community.eazybi.com/tags.md) --- ## [Aggregating Fix Versions regex to capture from the end](https://community.eazybi.com/t/aggregating-fix-versions-regex-to-capture-from-the-end/19148)
**Author:** [@nick.ehrlich](https://community.eazybi.com/u/nick.ehrlich)\ **Replies:** 2\ **Last updated:** [November 29, 2024, 3:14pm UTC](https://community.eazybi.com/t/aggregating-fix-versions-regex-to-capture-from-the-end/19148 "2024-11-29T15:14:10Z")
I have read the articles on how to aggregate fix versions that all start with the same characters but I can’t seem to get the regex right to aggregate by the same characters at the end. My current work around is to build… --- ## [Report based on Issue Description](https://community.eazybi.com/t/report-based-on-issue-description/9660)
**Author:** [@Osvalda](https://community.eazybi.com/u/Osvalda)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 9:50am UTC](https://community.eazybi.com/t/report-based-on-issue-description/9660 "2022-06-28T09:50:03Z")
Hello, I have imported Issue Description dimension. All of the issues in their description will have a repeating information. I need to be able to filter a specific sentence and make them as a separate type, then count… --- ## [How to get number from string](https://community.eazybi.com/t/how-to-get-number-from-string/14401)
**Author:** [@feluis23](https://community.eazybi.com/u/feluis23)\ **Replies:** 1\ **Last updated:** [December 4, 2023, 9:13am UTC](https://community.eazybi.com/t/how-to-get-number-from-string/14401 "2023-12-04T09:13:38Z")
Hello community, I am trying to make a calculation between two custom fields, goal and current result, where I want to show the fulfillment in percentage. The users who fill out these fields in jira do so without follo… --- ## [Split String with Delimiter](https://community.eazybi.com/t/split-string-with-delimiter/10610)
**Author:** [@Sonam](https://community.eazybi.com/u/Sonam)\ **Replies:** 4\ **Last updated:** [September 13, 2023, 6:26pm UTC](https://community.eazybi.com/t/split-string-with-delimiter/10610 "2023-09-13T18:26:57Z")
Hi, Do we have option to split string with delimeter as seperate fields. in eazyBI report ? For eg- “abc\>def\>ghi” , say we want to get values only after 3rd delimiter “\>” of whole string vlaue. which is ghi. Thanks, … --- ## [Search Sub-String with multiple, similar substrings](https://community.eazybi.com/t/search-sub-string-with-multiple-similar-substrings/10694)
**Author:** [@willmax](https://community.eazybi.com/u/willmax)\ **Replies:** 2\ **Last updated:** [November 9, 2022, 2:30am UTC](https://community.eazybi.com/t/search-sub-string-with-multiple-similar-substrings/10694 "2022-11-09T02:30:05Z")
Given a string (from Labels, on the Feature level), there are references for the Program Increment(s)\* in the Labels field. In this field, there will be 1 (or none) or, in some cases, 2 or more distinct PI reference valu… --- ## [Extract numbers from account name](https://community.eazybi.com/t/extract-numbers-from-account-name/9857)
**Author:** [@Getnoticed](https://community.eazybi.com/u/Getnoticed)\ **Replies:** 2\ **Last updated:** [June 30, 2022, 2:47pm UTC](https://community.eazybi.com/t/extract-numbers-from-account-name/9857 "2022-06-30T14:47:12Z")
Hi all, How can I extract the last 2 or 3 characters from the Tempo Account name in EazyBI? Example: the Tempo Account Name is “CUSTOMER - JUN22 - 100” or “CUSTOMER - JUN22 - 20” I want to extract the numbers “100” an… --- ## [Using ExtractString to pull Issue Key Prefix](https://community.eazybi.com/t/using-extractstring-to-pull-issue-key-prefix/5767)
**Author:** [@jeffscudder](https://community.eazybi.com/u/jeffscudder)\ **Replies:** 1\ **Last updated:** [January 18, 2021, 9:06am UTC](https://community.eazybi.com/t/using-extractstring-to-pull-issue-key-prefix/5767 "2021-01-18T09:06:35Z")
I have Issue Keys with varying lengths of prefixes such as ABCD-123, or ABCDEF-123. How can I use the ExtractString command to pull the prefix to the left of the dash ‘-’? I would like ABCD-123 and ABCDEF-123 to return… --- ## [Re-Order Fix Version by Name](https://community.eazybi.com/t/re-order-fix-version-by-name/3108)
**Author:** [@bill.armstrong](https://community.eazybi.com/u/bill.armstrong)\ **Replies:** 2\ **Last updated:** [November 7, 2019, 4:06pm UTC](https://community.eazybi.com/t/re-order-fix-version-by-name/3108 "2019-11-07T16:06:07Z")
The fix versions in my projects are all named the same and use a naming convention of yy.mm (i.e. 19.2 is Feb 2019, 19.6 is June 2019, etc.). When I create reports that use the Fix Version by Name option to combine data …