Calculated field - Extract substring from string

This article helps create a calculated field to extract a substring from a string and use that in a report.


  1. Consider Linked Issues: Key field has multiple linked issues generated in a report as shown below

  2. To get a substring at a certain position of the string, built the calculated expression as shown below

    The startPos and endPos parameters define the position of the length of the string.

  3. Use this calculated field in a report and the results are as follows

    The above Calculated field will work in Server/ Data Center/ Cloud environment.