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. 

[DavidP · Accepted solution]

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.

[mystasz]

Yes!! That's it. Thank you very much.