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?
Solved! Go to Solution.
@echuong1 Thank you.