Help, I'm trying to extract the e-mail addresses from a text file. Here a sample of the text file and the code I have. Each line is separate by a carriage return. I forget what the symbol for the carraige return is which I need for the delimiter. Any help would be great.
Ingar Bae Swnary [EMAIL PROTECTED] Ral Diaz Argentina [EMAIL PROTECTED] Cris Grass Uk [EMAIL PROTECTED] <CFFILE ACTION="Read" FILE="D:\INETPUB\WWWROOT\wWWROOT\ADMIN_HITTITE\file_1.txt" VARIABLE="emailtext"> <CFLOOP INDEX="fred" LIST="#ReplaceList(emailtext, """", "")#" DELIMITERS=";"> <CFIF #Trim(fred)# contains "@" AND #Trim(fred)# contains "." AND #Trim(fred)# IS NOT ""> <CFSET fred1 = #Trim(fred)#> <CFQUERY NAME="trotest" datasource="#Hitttie_Data_Source_dev#"> insert into test_email ( testemail ) values ( '#fred1#' ) </cfquery> </CFIF> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4