Sorry, still not clear. Give here the example of what is in the file, what you get in the table, and what should be after you apply the "correct format".


>Sorry. I will 'plain what I'm doing in:
>
>I am opening up a text file that has the data, about 57k lines/records. I am attempting to append that text file into an empty table. The problem comes in that the format of the text file is what I explain beofre and some of the data is getting in clean and some isn't.
>
>I thnk I need to be able to scan through the table (after all the text data has been appended) and convert all those fields that have the incrroect format to the correct format:
>
>scan testtable
> for field(x)
> correct format
> endfor
>endscan
>
>or something like that....does that clear things up a little bit?