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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!