Use Structure Formula to extract text from summary field

[Ian Porter]

Hi all,

I know its not the best set up but is there a way of using a custom column formula to extract the details in the summary field;

exmaple;

TDKI - impact for TDOS-7858

I would like to extract the TDOS-7858 from the text

The summary will not always be the same as the above and the placement of the TDOS code could move around. It will always be TDOS-xxxx though so i am hoping there is a function that i have not yet figured out.

[David Niro · Accepted solution]

Hello @Ian Porter ,

David from ALM Works here.

If you are on Structure 7.0 or higher, please try this:

summary.split(" ").filter($.match("TDOS-*"))

It will split the summary into an array, a space being the separator, and then filter out the components of the array that do not contain "TDOS-" as part of the text.

Let me know if it helps!

Best Regards,
David Niro
www.almworks.com

[Ian Porter]

thank you