Identify the Specific Alpha Numeric Combination example T123456 in

[naveenkumar1]

Hi All,

Require support to identify particular Pattern i.e., "TXXXXXX" where starts with Char T followed by 6 digit numbers in the provided text/String wefcew33cdsT123434-sdsd-sdf, Currently Excel formula I use =MID(E2,SEARCH("t",E2),7) , Alteryx?

Thanks

Naveen

[messi007 · Accepted solution]

@naveenkumar1,

RegEx is the best solution for this case:

Attached the workflow,

Hope this helps,

Regards,

[messi007]

@naveenkumar1,

If my answer solve your need please mark it as accepted solution it will help others 🙂

Regards,