#Chr(13)##Chr(10)# ? ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 03, 2003 8:51 AM Subject: CFLOOP, through list, delimiters help
> 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
