Automation help - Find and delete specific text from custom text field

[siond]

I have a custom field "Account" and some data has been placed there which I now want to remove in bulk... example..

Bookings - Mid 0123X000AAAAANQAY

The field type is 'Text'

How can I use Jira automations to seek out '0123X000AAAAANQAY' and replace with '' (nothing/delete it). I want to keep all other text in that field in tact.

So 'Bookings - Mid 0123X000AAAAANQAY' should become 'Bookings - Mid'

Thanks in advance!

[Bill Sheboy · Accepted solution]

Hi @siond 

To remove the text for an issue, you could use the Replace or ReplaceAll functions:

https://support.atlassian.com/jira-software-cloud/docs/smart-values-text-fields/#Smartvaluestextfields-replace-Stringtarget-Stringreplacement-

https://support.atlassian.com/jira-software-cloud/docs/smart-values-text-fields/#Smartvaluestextfields-replaceAll-Stringregex-Stringreplacement-

Kind regards,
Bill

[siond]

Thanks Bill! It worked!

For anyone else wondering the same here was my solution. I used the edit issue action and pasted in the replace smart value...

[Samuel Francis]

Good evening!

I am needing to replace the following information within the description

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":8,"Value":"Florida"}

and only display Florida

I have used the {{issue.description.remove and also 

                           {{issue.description.replace, 

I have only been able to remove 

#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference

[Bill Sheboy]

Hi @Samuel Francis 

What else is in your description, or is this the only text and you want it to only return the state name?

If there is more text...there are quite a few non-alphanumeric characters in your string, and so you will need to use a regular expression (regex) to remove them and keep only the state name (and any other description text).  In addition some of those characters are reserved for regex and so you will need to escape them in the search.

Please take a look at the linked documentation sources above, and their links to the regex formatting to get started.

Kind regards,
Bill

[Samuel Francis]

Hi Bill,

Thanks for the quick response.  The following information is the only info I would like to remove with automation after the issue is created.   

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":8,"Value":

Kind Regards,

Sam

[Bill Sheboy]

Yes, I understood that was what you are trying to do.  Please try using replaceAll() with a regular expression.  You may need to experiment a bit as some of the characters in your complex string are reserved, like quotation mark, and will need to be escaped such as with \"

[Sharla_Campbell]

Hi Samuel,

I have the same issue...were you able to work out how to remove the text?