Aug
12
2008
Read text files one line at a time with ColdFusion
Posted by Russell Brown at 11:38 AM
5 comments - Categories:
ColdFusion | Java | Development
This is a pretty basic use of the how to capitalize on ColdFusion / Java, but I recently had to show someone else how to do this as well as use it myself today to parse a very large CSV file.
<cfscript>
var f = "";
var endOfFile = false;
f = createObject("java","java.io.FileReader").init(arguments.csvFileLocation);
f = createObject("java","java.io.BufferedReader").init(f);
while (NOT endOfFile) {
line = f.readLine();
if (NOT isDefined("line")) {
endOfFile = true;
break;
} else if (len(line)) {
// {LINE PARSING CODE HERE}
}
}
f.close();
</cfscript>
Scott Stroz wrote on 08/12/08 12:19 PM
<cfloop file="{path to file}" index="line">
{code goes here}
</cfloop>