I have one Column ContractID..
I want to remove zeros how can i write in back end scripting..
Num(ContractID) as ContractID
replace(ltrim(replace(ContractID,'0',' ')),' ','0') as ContractID
This was taken from a previous discussion:
Remove Leading Zeros from Field while loading
Use like this below :
PurgeChar(ContractID , '0') as NewContractID
num(ContractID ) as NewContractID
May be like this.
Hi, try this:
REPLACE(LTRIM(REPLACE(FIELD, '0', ' ')), ' ', '0')as FIELD,
you can use:
it will cut of leading zeros.
You try this:
LOAD Values, Num(Values,'0') AS Values_New INLINE [
Retrieving data ...