> i am looping over a csv file. > doing this > > <cfloop index="newtext" list="#textfile#" delimiters="#CHR(13)##CHR(10)#"> > > This works fine for things like > item1,item2 > > but i get problem for > item1 (line breaks inserted into text), item2 > > Because of the line breaks in a text block i am getting more than 2 items. > > each row is delimited by a CR, however there are CR inside the csv as text > blocks. > > How do i loop over it cleanly. > THere are 7 items per row.
Are you using CFFile to read in the CSV? If so, why not try making a Text Datasource and letting ODBC handle the field and record breaks That's how I normally read in CSVs... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists