Hi team,
please help how to achieve this ?
in a column have texts as listed below, from each of those texts all I need is the number not the letters. in excel, i use text to columns multiple times to get the numbers. is there quick way to get it in Alteryx?
| BI-T2799868 | 
| T2755184 | 
| BI-T2799868 | 
| BI-T2799868 | 
| T2801672C - BI | 
| T2801672F - BI | 
| BI-TASK#2797909 | 
thank you
Solved! Go to Solution.
@ueni 
Regex should do it.
The simplest method for this is Regex Tool set to Parse with expression,
(\d+)
@PhilipMannering @Qiu thank you for your inputs, used the formula from @binu_acs and it worked in one go. thank you guys
