Hi John,
Works perfectly - thanks.
>Hi Allan,
>
>REPLACE field WITH STRTRAN(field,",","")
>
>
>>
>>In my application, I have a text file that I have to slice, dice and reformat. I have created the table to import the text file into and have created the required fields.
>>
>>Here's my problem - I'm not sure how to convert the text dollar amounts (i.e. 22,000,000.00) into a text dollar amount (i.e. 22000000.00) so that I can use the val function to convert it to a numeric value. Is there an relatively simple way to do this? The text file has about 10,000 records.
>>
>>Thanks.
Al Williams
Anola MB, CANADA