-
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)), Delimit…1 -
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, LENG…1 -
Re: FIND MULTIPLE DELIMITERS
YES!!!! Thank you..1