Skip to main content
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Cyril Hanquez and Hugo Sombreireiro and Reto Aeberli and Steven Peeters and Guust Nieuwenhuis and Aurélien Deleusière and Damien Bruyndonckx
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Cyril Hanquez ( @Fitzchev ) Hugo Sombreireiro ( @hsombreireiro ) Reto Aeberli ( @aeberli ) Steven Peeters ( @aikisteve ) Guust Nieuwenhuis ( @Lagaffe ) Aurélien Deleusière ( @adeleusiere ) Damien Bruyndonckx ( @damienbkx )

Using CFLoop To Iterate Over A File Line-By-Line In ColdFusion

Published in Comments (2)

Yesterday, at work, I had to take a CSV (Comma-Separated Values) file with 4.7 million lines of data in it and break it up into smaller files that each had 25K lines of data. I don't do a lot of file I/O (Input, Output) at work, so I'm a bit rusty. I ended up using the fileOpen(), fileReadLine(), and fileClose() functions to imperatively iterate over the file without reading it fully into memory. It wasn't until after I was done that I remembered the CFLoop tag can actually do all of that for me declaratively in ColdFusion.

I've actually written about using CFLoop to iterate over a file 13-years ago. But, practice makes perfect; and, I'm hoping that by exploring the topic once again I'll be better about recalling it next time.

First, let's look at the imperative approach that I used to consume the text file one line at a time:


	echo( "<h1> Using FileOpen() </h1>" );

	// When we OPEN a file (as opposed to reading a file), we allow the file to be
	// consumed as a stream. This reduces the pressure that we exert on the memory of the
	// server.
	namesSource = fileOpen( "./names.txt", "read", "utf-8" );
	nameIndex = 0;

	try {

		// Read one line in at a time until we hit "EOF" (End of File).
		while ( ! fileIsEof( namesSource ) ) {

			name = fileReadLine( namesSource );

			echo( "#nameIndex# : #name# <br />" );


	} finally {

		fileClose( namesSource );



Instead of reading the entire file into memory at one time, the fileOpen() function returns a file object, which can be used to stream data from the file into memory as needed. The fileReadLine() function takes the file object and consumes just enough character data to return the next line. And finally, when we're done consuming the file (when we hit the "End-of-File" state), we close the file, removing any potential locking issues.

This code works well enough; but, we have to manage all the file details on our own. And, when we see just how little code we end up having in our CFLoop solution, even the above code seems absurdly verbose! The following ColdFusion code does the exact same thing, only we're using a declarative approach, offloading all of the heavy-lifting to the CFML engine (Lucee CFML in this case):


	echo( "<h1> Using CFLoop </h1>" );

	// Instead of using FileOpen(), and explicitly reading lines and closing files when
	// we're done, we can defer all of the heavy-lifting to ColdFusion itself. The CFloop
	// tag encapsulates all of that logic!
		index = "nameIndex"
		item = "name"
		file = "./names.txt"
		charset = "utf-8"

		echo( "#nameIndex# : #name# <br />" );



As you can see, instead of dealing with all the file I/O explicitly in the code, we're simply telling ColdFusion that we want to iterate of a file, and we're letting the CFLoop tag implicitly figure out how to do that most effectively. It's so easy!

And, when we run both of these ColdFusion files side-by-side, we get the following output:

Top lines of a file read using both imperative fileOpen() code and declarative CFLoop code.

As you can see, each approach yields the same outcome: reading the text file line-by-line. However, the declarative CFLoop approach uses significantly less code. It's ColdFusion just amazing!

Want to use code from this post? Check out the license.

Reader Comments



I love that ColdFusion has lots of ways to do stuff; but, it does mean that it's hard to keep all the options in one's head.

Post A Comment — I'd Love To Hear From You!

Post a Comment

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
Ben Nadel