Regular Expressions Make CSV Parsing In ColdFusion So Much Easier (And Faster)

<!--- Create data file path. --->
<cfset strCSVPath = ExpandPath( "data.csv" ) />
 
<!---
	Create sample data for a web site. Make this data beefy
	to simulate what kind of stuff might actually be coming
	out of a system-generated CSV file.
--->
<cfsavecontent variable="strCSV">"Kinky Solutions: A Student's Perspective","http://www.bennadel.com","Ben J. Nadel","ColdFusion,Web Development,CSS,Javascript,jQuery,SQL,SEO Optimization",,,09/21/2007 07:31:15,true,true,false,"5,340","34",,true</cfsavecontent>
 
<!--- Repeat string 10,000 times. --->
<cfset strCSV = RepeatString(
	strCSV & Chr( 13 ) & Chr( 10 ),
	(10 * 1000)
	) />
 
<!--- Write data to file. --->
<cffile
	action="write"
	file="#strCSVPath#"
	output="#strCSV#"
	/>

For Cut-and-Paste