how to truncate concatenated strings with a separator
Hi guys,
Assuming I have a concatenated strings with different length but with the same separator..
To illustrate: I have company code+ledger+asset code but with "" in between.. This 3 do not have the same length..
Assuming here are my data
1. 11112345612456
2. 11111234124
3. 1112345234
How can i get the mid character using the mid formula.. What i did was this formula:
MID(Concatenated string, FIND("", Concatenated string), LENGTH(Concatenated string))
But i am not getting the mid characters only.
Appreciate your help!
Thanks,
Elaine
Best Answer

As per Planual 2.0818
https://community.anaplan.com/t5/BestPractices/ThePlanual/tap/49773
It is best to break the formulas up and keep the component parts in separate line items
I have broken then all up for an example, but you could combine some together if you were short of space
I hope that helps
David
3
Answers

Hi @elaine.novel ,
Try this Formula,
MID(Concatenated string, FIND("", Concatenated string) + 1, FIND("", Concatenated string, FIND("", Concatenated string) + 1)  FIND("", Concatenated string)  1)
It is best to divide the formula to small ones and use them.
Example: Find out "1st  Place" and "2nd  Place"
Regards,
Vignesh M
1 
Hi David, was able to come up to 1 formula using the steps you sent. Thanks! 🙂
0 
Hi Vignesh,
Thank you for taking time to respond to my inquiry. I did the formula but I think the Length formula is needed to complete the formula. But I sincerely appreciate your answer. 🙂
Thanks again, Elaine
0