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?

Accepted answers

rob_marshall

@ToddKavanaugh ,

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

Does this help?

Rob

All comments

rob_marshall

@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

ToddKavanaugh

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?

rob_marshall

@ToddKavanaugh ,

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

Does this help?

Rob

ToddKavanaugh

YES!!!! Thank you..

alan

This was very helpful. Thank you to all contributors!

Quick Links

Can you help?

Unanswered questions

I attempted the Anaplan Level 2 Model Building - On Demand Sprint 1 exam many times due to system i
I attempted the Anaplan Level 2 Model Building - On Demand Sprint 1 exam many times due to system issues and Sprint 1 exam got locked. Can you please support to resolve this issue soon as I need to resume doing my Sprint 1 exam and next lessons.
Anaplan Matillion Integration
I have a requirement to extract last 90 days data from an Anaplan model through Matillion. I wanted to know is there any API which I can use to achieve the same? I have taken a look at the (Integration APIs) Bulk API as well as Transactional API and none of them has a relevant query parameter which I can use to apply the…
How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?