How to remove leading zeros without removing the zeros in the middle and end

[AquaCapriLyn]

Hello,

 I am trying to remove leading zeros from the left of a string. I have values that look like 'GH54673045', 000005674505, MFE6453-GW, 000000000532, and 00034002GER. Could you please help me resolve this issue? I tried using the num function but it returns Null values. I also tried the Replace function but it removed the zeros in the middle. For example, 000000004230043 would return 42343 instead of 4230043

[Chanty4u]

Try this

    Text(Num(YourField, '0')) AS   new field

[AquaCapriLyn]

Hello @Chanty4u, I tried it but it is returning '-' for all values