Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Help Required on Regex for parsing of the string

Bhargav
6 - Meteoroid

Hi Team,

I'm new to alteryx and was trying to parse data in a column "Task Name" using Regex but something seems to fail. This task name consists of many tasks aling with their material numbers . For Eg, In task name column which is shown below conists of tasks like "Assembly", "Approval" and material numbers like "1-1718647-1", "2314055-2" etc. 

 

I wanted to parse "1-1718647-1",  "2314055-2" material numbers out of these columns and want the output to be shown as below.

I used this regex expression "(^\d+\>\W\d+|\<\W\d\>)" to get the output but seems to fail.

Can anyone help on this?

Also, have attached excel file which has these columns for reference.

 

Task NameRegexOut
Assembly 
Approval 
1-1718647-1 Housing 2 Pos.1-1718647-1
1718654-1 Retainer 3 Pos.1718654-1
 1-1802616-1 6 Pos. MCON1-1802616-1
1802572-1 Housing1802572-1
1-1802083-11-1802083-1
0-2366427-40-2366427-4
2314055-22314055-2
53P 
13 REPLIES 13
atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @Bhargav 

 

Cheers and Happy Analyzing 😀

Bhargav
6 - Meteoroid

Thanks Philip !!! It was a great help fro you

Bhargav
6 - Meteoroid

Hi,

An another help needed after parsing the data.

If I want to repeat this material Id from Regexout column and want to see output as  below, I know I have to use Multi Row formula, but I'm not getting the logic.

Could you please help below ,

Have attached an excel file which has the column Part number i.e after using Regex where I need the output as shown below.

RegexOutOutput
 2314054-2
 2314054-2
2314054-22314054-2
 2314054-2
 2314054-2
2282255-52282255-5 
 2282255-5 
 2282255-5 
1-1718647-11-1718647-1
 1-1718647-1
 1-1718647-1
atcodedog05
22 - Nova
22 - Nova

Hi @Bhargav 

 

Here is a workflow for the task.

Workflow:

atcodedog05_0-1605257131131.png

Output:

atcodedog05_1-1605257154364.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Labels
Top Solution Authors