No longer applicable.
![cabbsman](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!