here u go .... others can explain any code... <cfset newline = chr(13) & chr(10)> <cfset filename="master_email.txt"> <cffile action=read file="#filename#" variable="Emails"> <cfset emailarray = ListToArray(#Emails#,#newline#))>
<!--- stript out duplicates here ---> <cfoutput> #Arraylen(emailarray)#<br> </cfoutput> <cfloop from=1 to=#Arraylen(emailarray)# index=i> <cfquery > insert into Table (email) values ('#emailarray[i]#') </cfquery> <cfoutput> #emailarray[i]#<br> </cfoutput> </cfloop> WG ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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.