nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Bill Sheboy

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

All comments

Bill Sheboy

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_mxru28

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

automation