Extracting numbers

[rajputakansha]

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

[benakesh · Accepted solution]

Hi @rajputakansha ,

You can use  these functions  to extract  first  character .

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

[Thableaus · Accepted solution]

Hi @rajputakansha 

Filter tool using Custom Filter

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

Cheers,