Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

parse text after a constant string and numeric value

MysticalAz
8 - Asteroid

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. 

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

Hi @MysticalAz,

 

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

 

DavidP_0-1647390867486.png

 

 

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

 

DavidP_1-1647391014056.png

 

MysticalAz
8 - Asteroid

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

Labels