Help Required on Regex for parsing of the string

[Bhargav]

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 Name	RegexOut
Assembly
Approval
1-1718647-1 Housing 2 Pos.	1-1718647-1
1718654-1 Retainer 3 Pos.	1718654-1
1-1802616-1 6 Pos. MCON	1-1802616-1
1802572-1 Housing	1802572-1
1-1802083-1	1-1802083-1
0-2366427-4	0-2366427-4
2314055-2	2314055-2
53P

[atcodedog05]

Happy to help 🙂 @Bhargav 

Cheers and Happy Analyzing 😀

[Bhargav]

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

[Bhargav]

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.

RegexOut	Output
	2314054-2
	2314054-2
2314054-2	2314054-2
	2314054-2
	2314054-2
2282255-5	2282255-5
	2282255-5
	2282255-5
1-1718647-1	1-1718647-1
	1-1718647-1
	1-1718647-1

[atcodedog05 · Accepted solution]

Hi @Bhargav 

Here is a workflow for the task.

Workflow:

Output:

Hope this helps 🙂

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