Hi,
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