FIND MULTIPLE DELIMITERS

Highlighted
Occasional Contributor

FIND MULTIPLE DELIMITERS

I am trying to take a 3 part Unique ID with delimiters and separate it at the delimiters. I can achieve this for the first 2, but not the last part.

 

ex: 123-0542-236541

LEFT(NAME(ITEM(LIST)), Delimiter in Item Name - 1) = 123

RIGHT(NAME(ITEM(LIST)), Delimiter in Item Name) = 0542

Delimiter in Item Name = FIND("-", Item Name)

Item Name= NAME(ITEM(LIST))

 

I can not parse the digits after the last delimiter. Anyone? Is it possible? Any Ideas on how to parse it a different way? 

 

5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: FIND MULTIPLE DELIMITERS

@ToddKavanaugh ,

 

Absolutely...Do a length of the item and then subtract the number obtained from the 2nd delimiter.  To do this, store the 2nd delimiter in a line item.  Also, if you want to make this the most performant, create a line item just for the item and then reference that line item.  This way, you don't have to keep doing the NAME(Item(list)).

 

Hope this helps,

 

Rob

Highlighted
Occasional Contributor

Re: FIND MULTIPLE DELIMITERS

Rob, Thanks.. I am going to play with this. I think i understand.

Totally with you on the NAME(ITEM(LIST). Only do it once. LEFT(Item Name, Delimiter in Item Name - 1)

I have the length already, LENGTH(Item Name). My only confusion is how to obtain the number from the second delimiter? can you explain that a little more?
Highlighted
Master Anaplanner/Community Boss

Re: FIND MULTIPLE DELIMITERS

@ToddKavanaugh ,

 

Sure, take a look at the below...I used RIGHT(LEFT(...)) but you can also use MID.

 

2019-06-21_09-06-48.png

 

Does this help?

 

Rob

Highlighted
Occasional Contributor

Re: FIND MULTIPLE DELIMITERS

YES!!!! Thank you..
Highlighted
Occasional Contributor

Re: FIND MULTIPLE DELIMITERS

This was very helpful. Thank you to all contributors!