derive number only from alphanumeric text

[ueni]

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

[Qiu]

@ueni 
Regex should do it.

[binuacs · Accepted solution]

@ueni Another option using RegEx formula

Spoiler

[PhilipMannering]

The simplest method for this is Regex Tool set to Parse with expression,

(\d+)

[ueni · Accepted solution]

@PhilipMannering @Qiu thank you for your inputs, used the formula from @binuacs and it worked in one go. thank you guys