Trim values

[abhaysingh]

Dear All

i have a field in which value are numeric i want to trim it from left,

values are like 0000022223

                         0000022224

                         0000022225

                         0000022226

i want the output like

                              22223

                              22224

                              22225

                              22226

Regards

Abhay

[jonathandienst]

Hi

Num('0000022223') will return 22223. you can use this in your load script:

LOAD Num(myField) As MyField,

     ....

Replace the field name with the correct names for your model.

HTH

Jonathan

[jyothish8807]

Hi Abhay,

Use Num(FieldName) as Field,

Else you can use:

right(Fieldname,5) as Field

//if your numbers are not starting with 0.

Regards

KC

[maternmi]

Hi,

try this.

right(your field), 5)

BR

Michael