Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi,
try this.
right(your field), 5)
BR
Michael