parse text after a constant string and numeric value

mystasz

Hi Community,

I have a attached document which contains sample and expected output. Trying to parse everything after "items.[SOME NUMBER]."

The number can be any number >= 0 and is the unique identifier for a group of fields, or a Record ID. I attempted a few Regex methods with not much luck. Any help would be appreciated. 

Regex Parse.xlsx

DavidP

Hi @mystasz,

You can definitely do it with regex, like this: Regex: items\.(\d+)\.(.*)

But you could also do it with a Text to columns.