Remove text and get only some strings using automation

Aaron Pavez _ServiceRocket_

Hi Everyone!

Ive been trying to do this using automation. I'm able to remove only one set of IDs from the field. I have issues removing all the others.

This is the custom field value:

[5005e00000WW2BuAAL|https://urlhere/5005e00000WW2BuAAL ], [5005e00000WU4YGAA1|https://urlhere/5005e00000WU4YGAA1 ], [5005e00000WU1fGAAT|https://urlhere/5005e00000WU1fGAAT ]

I want to remove everything else and keep the IDs before the first square bracket and the pipe.

I want to have this in another field:

5005e00000WW2BuAAL,5005e00000WU4YGAA1,5005e00000WU1fGAAT

With remove, replace, substring I can remove the first one. Im not able to remove the other two Ids, or three or four.

but this field can change, I can add more, delete some. So the automation should be able to capture IDs (which might not start with 5005. I haven't tried using that approach though)

Any help is appreciated!

Regards

Aaron

Bill Sheboy

Hi @Aaron Pavez _ServiceRocket_ 

The custom field appears to contain a list of links, with a comma delimiter.  Is that correct?

If so you could use the list and text functions to help parse the data:

• use the split() function to separate the values
• use inline iteration to walk over each one
• extract the ID values with the substringBetween() function
• use the join() function to merge values back together into a text string, controlling the new delimiter

For example:

{{issue.myCustomField.split(",").trim().substringBetween("[", "|").join(",")}}

Kind regards,
Bill