topic Re: Sustring function in QlikView

Sustring function

sspawar88 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 23 Jan 2017 06:42:59 GMT

Why can't simply

Right(FieldName,2)

asgardd2 — Mon, 23 Jan 2017 06:50:42 GMT

Hello!

num(FieldName,'00')

sspawar88 — Mon, 23 Jan 2017 06:54:45 GMT

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

Anil_Babu_Samineni — Mon, 23 Jan 2017 07:17:11 GMT

Can you send the Real data which demonstrates the Output

MK_QSL — Mon, 23 Jan 2017 07:17:40 GMT

Num(YourField,'00') as YourField

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

surendraj — Mon, 23 Jan 2017 07:20:27 GMT

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 — Mon, 23 Jan 2017 09:13:56 GMT

Great !! Thank You Manish !!

varshavig12 — Mon, 23 Jan 2017 09:14:09 GMT

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

sspawar88 — Mon, 23 Jan 2017 09:14:45 GMT

Right