Alteryx Designer Desktop Discussions

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

Capture 3 groups with REGEX

hellyars
13 - Pulsar

A little REGEX...challenge....

 

Here is the sample text  (each line is a record). 

<tr><d>1</d><d>1</d><d>1</d><d>1</d><d>1</d>12600433|BEZEL, AUTOMOTIVE TRIM|999999|B.4|TACO|533.0|millimeter|</tr>||
<tr><d>1</d><d>1</d><d>1</d>12600457-002|SCREW,BUTTON,SOCKET HEAD ,M6-1.00X20 C10.9 MAGNI BLACK|999999|B.3|TACO|2.0|each|</tr>||
<tr><d>1</d>12600041METHOD4|PLATING AND COATING REQUIREMENTS|999999|C.2|TACO|1.0|as needed|</tr>

 

I want to capture 3 groups (see image below).  Group 1 is the Green below.  Group 2 is Red.  Group 3 is Orange.  

 

I can capture Group 1+2 and Group 3 in Alteryx using: 

(<d>.*?)\|(.*$)

 

I can Capture all 3 Groups using a REGEX test case on REGEX101.com.  BUT, I can get it to work in Alteryx.  

 

I tried this...

 

(<d>.*)\<\/d>(.*?)\|(.*$)

 

What am I doing wrong?

 

Screen Shot 2020-08-19 at 2.19.04 PM.png

2 REPLIES 2
echuong1
Alteryx Alumni (Retired)

I believe this is what you're looking for?

 

echuong1_0-1597863043715.png

 

hellyars
13 - Pulsar

@echuong1  Thank you.  

Labels