Parse a cell with colon : delimited variables

Michael Tuccillo

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

1. 09:40 PST, Wed 12/25/2019 to a column that I named, "START"
2. ONGOING to a column that I named, "END"
3. 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!

Paul Newcome

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.