Truncation help

[BHOOMIKA KAPOOR]

Hi,

I am using a  JQL query to extract some information from my summary field.

My summary filed is : 'I am a girl and my id is CB273899128-A1. 

I just want to extract the CB273899128-A1 from the summary, Can you please help me with this.

[Mikael Sandberg]

Hi @BHOOMIKA KAPOOR,

Welcome to Atlassian Community!

JQL cannot truncate/extract parts of the summary field. In order to do that you would have to use something like automation which can extract substrings from fields using smart values. You can learn more about text smart values here.

[Mikael Sandberg]

And just to clarify, smart values can only be used within an automation rule, it cannot be used outside of that. So if you are trying to update a custom field with the extracted value that can be done within an automation rule.

[John C]

As @Craig Nodwell mentioned, it would be good to get an understanding of what you want to be able to achieve with this string once/if it is extracted.

For example, if you wanted to say extract the 'CBxxxxxxxx-A1' string from a Summary field, and store that value in another field there will be a way of doing that with a Jira Automation rule and using regular expressions.

Share a little more about what outcome you hope to achieve, and we can assist further.

[Craig Nodwell]

Hi @BHOOMIKA KAPOOR welcome to the community.  What are you trying to achieve with this extraction of data from the summary field?  Or are you just trying to search on that value?