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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.