Thanks! That works. I should have thought of that. And I retract my comment about CF deficiency.
----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 26, 2002 4:46 PM Subject: Re: CFFILE READ and line delimiter > Bruce Holm wrote: > > I have a text file containing records of comma delimited data. > > I was planning to read the file with CFFILE and then loop over each line (record) and INSERT into a db. > > Problem is, I can't figure out how to delimit each line. The reg. expression "\n" doesn't work as a delimiter for treating the CFFILE variable as a List. > > Newline is ASCII 10. Carriage return is ASCII 13. > > > > Any ideas how to deal with this glaring deficiency in CF? > > You can't figure it out and therefore it is a glaring deficiency? > > Jochem > > ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

