Remove leading 0s from field in data load editor

[Vinni2000]

I have field  and it's not numeric data type  and it has leading zeros to value so  I want to remove these 0s

[Kushal_Chawda]

@Vinni2000  try below

LOAD *,
     replace(Ltrim(Replace(YourField,0,' ')),' ',0) as NewField
FROM Source

[Vinni2000 · Accepted solution]

Num(Num#(Field,#,##0)) as aliasname