No longer applicable.
Getting answer in a different article. Removing question from this one
Answers
-
Found answer here. https://community.smartsheet.com/discussion/66859/pull-text-from-string-using-delimiter Although I can;t figure out how to parse and find the 5th deleimter vs the 3rd as in the example.
-
Compared to Python, there are some pretty serious limitations. Yes, there are methods of parsing based off of a delimiter, pipe included. Unfortunately, you can't really iterate over the data with something like a while loop or just split the data with SPLIT like you would in Excel.
I think the best way is using a combination of LEFT()/MID()/RIGHT() along with FIND() and SUBSTITUTE(). There are a few threads here already that discuss some different implementations. The one I am linking below is probably not the best, but it was easy to find from my comment history and can get you started. If you understand Python, you can probably figure out the concept.
Help Article Resources
Categories
Check out the Formula Handbook template!
