Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Vinni2000
Contributor III
Contributor III

Remove leading 0s from field in data load editor

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

1 Solution

Accepted Solutions
Vinni2000
Contributor III
Contributor III
Author

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

View solution in original post

2 Replies
Kushal_Chawda

@Vinni2000  try below

LOAD *,
     replace(Ltrim(Replace(YourField,0,' ')),' ',0) as NewField
FROM Source
Vinni2000
Contributor III
Contributor III
Author

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