Solved: remove initial zeros - Qlik Community

rupaliqlik · ‎2021-11-01

Hi Folks,

Want to remove initial 2 zeros from below field.

0040111100

expected output.

40111100

@abhijitnalekar

Thanks,

Rupali Ethape

ManuelRühl · ‎2021-11-01

try

=right(FIELD,len(FIELD)-2) as FIELD_NEW

Manuel Rühl

View solution in original post

ManuelRühl · ‎2021-11-01

try

=right(FIELD,len(FIELD)-2) as FIELD_NEW

Manuel Rühl

AshutoshBhumkar · ‎2021-11-01

Hello,

You can try Num#(Dimension)+0

Anil_Babu_Samineni · ‎2021-11-01

You can use

=Trim(Num('0040111100'))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful