Sustring function

[sspawar88]

Hi,

I have field in which numbers are as like 00000000001, 00000000025,00000000035 etc

i want to replace first 9 zeros with null i.e 01,25,35

How can i acieve this?

[Anil_Babu_Samineni]

Why can't simply

Right(FieldName,2)

[asgardd2]

Hello!

num(FieldName,'00')

[sspawar88]

this should be only when those 9 digits are zero. how can we identify the zero's in string?

[Anil_Babu_Samineni]

Can you send the Real data which demonstrates the Output

[MK_QSL · Accepted solution]

Num(YourField,'00') as YourField

This will make sure that you have at least 2 digit for any number.

[surendraj]

Hi,

You can count the number of zeros in string by using

SubStringCount(Feildname,'0')

if you want to remove the zeros in string

replace(Feildname,'0','')

Hope this may help you!!

--Surendra

[sspawar88]

Great !! Thank You Manish !!

[varshavig12]

=if(sum(left(YourField,9))=0,mid(YourField,10),no) as YourField

[sspawar88]

Right