RegEx - Split to Rows Second Instance of a Number

Kristie_Pires

Hello community! 

I need help using the RegEx tool to split to rows the second instance of a number. Whenever there is a second number on the Request Type field, that information should be moved to another row. I can do the additional clean up needed. 

For example, I have the first table and want what's on the second table.

ID	Request Type	Start Dt	Colleague
1	2 - Letter and 10 - Annual Review	6/6/2023	Ana
2	10- Annual Review	6/4/2023	Peter
3	3 - Waive Letter & 2 - Letter	6/3/2023	John

ID	Request Type	Start Dt	Colleague
1	2 - Letter	6/6/2023	Ana
1	10 - Annual Review	6/6/2023	Ana
2	10- Annual Review	6/4/2023	Peter
3	3 - Waive Letter	6/3/2023	John
3	2 - Letter	6/3/2023	John

acarter881

Hello, @Kristie_Pires.

Please see the attached workflow for one method of doing this.

regex for new rows.yxmd