zeros ?

[#1]

Hi All,

I have one Column ContractID..

Values:

000238

000567

000786

001234

001435

028978

I want to remove zeros how can i write in back end scripting..

[tresesco]

Num(ContractID) as ContractID

[#3 · Accepted solution]

replace(ltrim(replace(ContractID,'0',' ')),' ','0') as ContractID

This was taken from a previous discussion:

Remove Leading Zeros from Field while loading

[dmohanty]

Hi,

Use like this below :

PurgeChar(ContractID , '0') as NewContractID

OR

num(ContractID ) as NewContractID

[ashfaq_haseeb]

Hi,

May be like this.

Regards

ASHFAQ

[fkeuroglian]

Hi, try this:

REPLACE(LTRIM(REPLACE(FIELD, '0', ' ')), ' ', '0')as FIELD,

good luck

Fernando

[#7]

you can use:

num(youFieldName)

it will cut of leading zeros.

regards,

MT

[fernando_tonial]

You try this:

Data:
LOAD Values, Num(Values,'0') AS Values_New INLINE [
    Values
    000238
    000567
    000786
    001234
    001435
    028978
];

Best Regards.

Tonial.