Speedy CSV file parsing using ColdFusion

Posted on : October 15, 2007 1:23 PM | Posted by : Troy
Related Categories: RegEx,ColdFusion

A client of mine needed a solution to bulk import CSV files of affiliate coupon data into his database. I found a great blog by Ben Nadel who covered the exact topic I was looking for: CSVToArray() ColdFusion UDF For Parsing CSV Data / Files

After I implemented Ben's function, we were able to import 1000 records in about 1.6 seconds. Not bad, considering it used to take him hours of time to manually input the coupons one at a time.

Thanks Ben (and Steven Levithan who helped improve the RegEx)

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 3149 Views
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

There are no comments for this entry.

[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9.002. Contact Blog Owner