Parse a cell with colon : delimited variables
I need to select the string associated with each of the Tag names START: END: SCOPE: Are there command/s in Smartsheet to select the data and copy to a column on the same row as the string? Below is the example of data in a single Cell.
"START: 09:40 PST, Wed 12/25/2019 END: ONGOING SCOPE: Foo site 10G circuit to FOO hubsite is down."
In this example, I need to copy
- 09:40 PST, Wed 12/25/2019 to a column that I named, "START"
- ONGOING to a column that I named, "END"
- Foo site 10G circuit to FOO hubsite is down. to a column named "SCOPE"
The strings can be variable sized. However, the Tag names and colons are consistent within each string.
I appreciate any assistance.
Thanks!
Comments
-
HERE is an example of something I have done that is very similar. I just had different sections to parse out, but the concept is still the same. The basic way it works is that you enter each section into row 1, then use those cells to designate which portion of the string gets pulled based on MID formulas.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!