In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

derive number only from alphanumeric text

ueni
6 - Meteoroid

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

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@ueni 
Regex should do it.

1221-ueni.PNG

binu_acs
21 - Polaris

@ueni Another option using RegEx formula

 

Spoiler
binuacs_1-1640075264683.png

 

PhilipMannering
16 - Nebula
16 - Nebula

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

 

(\d+)

 

ueni
6 - Meteoroid

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

 

ueni_0-1640132342095.png

 

Labels
Top Solution Authors