A Parsing CSV File Routine

				
//**************************************
// Name: A Parsing CSV File Routine
// Description:If any of you already know, parsing a CSV file is a pain in the !@#*! However, some people love to export their data via this format. So, I had a little time on my hands and wanted to share this bit of code with you. It is by no means "clean" and in pure OO format, but it gives you an idea of the pain of parsing this type of file/format.
// By: Steven Jacobs
//
//This code is copyrighted and has// limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=4666&lngWId=2//for details.//**************************************

/*
Remember, this is not "clean" and I did not write the other 
functions (such as get number of lines in the file or # of columns).
All this does is parse out a CSV file in this format:
<text>,<text>,...,"<text>,<text>,...",<text>,<text>,...,"<text>,<text>"
Have fun....
Author: Steven Jacobs
Date: 02/12/2005
PS: I did not use StringTokenizer or the split function because the format of the file did not adhere the return values to their proper strings (due to the delimiters --> the comma).
*/
import java.io.*;
public class parseCSV {
 
 public static void main(String args[]) throws IOException {
String thisLine;
String[] fullText = new String[100]; //number of possible lines in your file
int counter = 0;
String fName = "<your *.csv file>";
FileInputStream fis = new FileInputStream(fName);
DataInputStream myInput = new DataInputStream(fis);
while ((thisLine = myInput.readLine()) != null) {
 System.out.println("---------------------------------\nBegin Parsing");
 
int sPos = 0;
int ePos = 1;
int tDelim = 0;
String d = "";
int colCount = 0;
int collCount = 0;
boolean fMe = false;
boolean finalCol = false;
while ( ePos < thisLine.length()) {
 sPos = thisLine.indexOf(",", ePos);
 tDelim = thisLine.indexOf(",\"", ePos);
 
 if (tDelim == ePos) {
fMe = true;
collCount = ePos + 1;
 while (collCount <= thisLine.indexOf("\",")) {
collCount += 1;
 }
colCount += 1;
sPos = collCount;
 }
 
 if (colCount == 47) { //Get Max count of columns
finalCol = true;
collCount = ePos + 1;
 while (collCount <= thisLine.lastIndexOf("\"")) {
collCount += 1;
 }
colCount += 1;
sPos = collCount;
 }
 
 if (sPos == -1) {
d = thisLine.substring(ePos,thisLine.length()); 
System.out.println(d);
break;
 }else if(ePos == 1) {
d = thisLine.substring(ePos-1,sPos);
System.out.println(d);
 }else{
if (fMe) {
 d = thisLine.substring(ePos + 1, sPos);
 fMe = false;
}else if (finalCol) {
 d = thisLine.substring(ePos, sPos);
 finalCol = false;
}else{
 d = thisLine.substring(ePos, sPos);
}
System.out.println(d);
 }
 
 colCount += 1;
 ePos = sPos + 1;
}
counter++;
fullText[counter] = thisLine;
System.out.println("\nEnd Parsing\n---------------------------------\n\n");
}
}
 
}