community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Extracting numbers

Highlighted
Asteroid

Hi all,

 

I have one silly question. I have a column of 5 digit numbers(for the non-5 digit ones, I left padded extra "0"s)

 

12345

02000

00223

01230

23450

23413

and so on..

 

I want to extract the numbers that starts with 2. My answer should be: 23450 and 23413.

How can I get this without getting 02000 or 00223?

 

Thanks

 

Quasar

Hi @rajputakansha ,

You can use  these functions  to extract  first  character .

left(string,1)  = '2'  or  startswith(string,'2')

Alteryx Certified Partner
Alteryx Certified Partner

Hi @rajputakansha 

 

Filter tool using Custom Filter

Formula: Left(ToString([Field]), 1) = "2"

 

Cheers, 

Labels