>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.
>
How about using CHRTRAN() to remove the commas?
? CHRTRAN('22,000,000.00',',','') && prints 22000000.00
If you need to be a bit more selective,and not remove all commas, just the ones preceded and followed immediately by a digit, try the Vbscript.RegExp object from the WSH:
oRegExp = CREATEOBJ('Vbscript.RegExp')
oRegExp.pattern = "(\d{1}),(\d{1})"
? oRegExp.Replace('This, string has 1,000 different, things with 1 ,1 commas',"$1$2")
Regular expressions RULE!