Hi, We are trying to parse the below data and the the output required is the transaction ID's...I'm not sure how to use regex and achieve the below target. TextOutputSUKY --HWSC7E110- 930392071930392071PURL - HWCD7E118 - NAGUR - 612304939612304939SHUBHAM BANSAL -DLCC7W8 -101230577-DELHI101230577KAR -HWCD7A3 -874090430-874090430

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

Parse

Hi,

We are trying to parse the below data and the the output required is the transaction ID's...I'm not sure how to use regex and achieve the below target.

Text	Output
SUKY --HWSC7E110- 930392071	930392071
PURL - HWCD7E118 - NAGUR - 612304939	612304939
SHUBHAM BANSAL -DLCC7W8 -101230577-DELHI	101230577
KAR -HWCD7A3 -874090430-	874090430