Linked Table field...strip off leading zeros of text

[Inyo55]

My table is linked to a text file. One of the numbers in
that text file has 2 leading zeros. I do not want the
leading zeros to be imported into the Table. How do I
strip off the two leading zeros in the Text Field? I
cannot change the field to a Number; it must remain as
Text because of other things in the DB that join to it.

thanks,
Bob

 

[John Vinson]

My table is linked to a text file. One of the numbers in
that text file has 2 leading zeros. I do not want the
leading zeros to be imported into the Table. How do I
strip off the two leading zeros in the Text Field? I
cannot change the field to a Number; it must remain as
Text because of other things in the DB that join to it.

thanks,
Bob

Try appending

Cstr(Val([fieldname]))