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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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

