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.

Instructions

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

   Open

   

   
   
   
   

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

   Open

   

   
   
   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