https://community.qlik.com/t5/QlikView/Remove-leading-0s-from-field-in-data-load-editor/m-p/2068876#M1223567 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/214178">@Vinni2000</a>&nbsp; try below</P> <LI-CODE lang="javascript">LOAD *, replace(Ltrim(Replace(YourField,0,' ')),' ',0) as NewField FROM Source</LI-CODE> Mon, 08 May 2023 19:59:46 GMT Kushal_Chawda 2023-05-08T19:59:46Z https://community.qlik.com/t5/QlikView/Remove-leading-0s-from-field-in-data-load-editor/m-p/2068854#M1223564 <P>I have field&nbsp; and it's not numeric data type&nbsp; and it has leading zeros to value so&nbsp; I want to remove these 0s</P> Mon, 08 May 2023 18:36:34 GMT https://community.qlik.com/t5/QlikView/Remove-leading-0s-from-field-in-data-load-editor/m-p/2068854#M1223564 Vinni2000 2023-05-08T18:36:34Z https://community.qlik.com/t5/QlikView/Remove-leading-0s-from-field-in-data-load-editor/m-p/2068876#M1223567 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/214178">@Vinni2000</a>&nbsp; try below</P> <LI-CODE lang="javascript">LOAD *, replace(Ltrim(Replace(YourField,0,' ')),' ',0) as NewField FROM Source</LI-CODE> Mon, 08 May 2023 19:59:46 GMT https://community.qlik.com/t5/QlikView/Remove-leading-0s-from-field-in-data-load-editor/m-p/2068876#M1223567 Kushal_Chawda 2023-05-08T19:59:46Z https://community.qlik.com/t5/QlikView/Remove-leading-0s-from-field-in-data-load-editor/m-p/2071377#M1223629 <P>Num(Num#(Field,#,##0)) as aliasname</P> Mon, 15 May 2023 13:38:19 GMT https://community.qlik.com/t5/QlikView/Remove-leading-0s-from-field-in-data-load-editor/m-p/2071377#M1223629 Vinni2000 2023-05-15T13:38:19Z