CSV file Read Problem! Help needed

[abc73]

I am using the following code to read data from a csv file. Can someone help me when I have a numeric with leading zero's in my csv file
in the output the leading zero's are automatically being removed. I want to keep the leading zero's. e.g. I have a following csv-file:

1234,Mike,1235 XYZ,1
0001234,,,2
12340000,Test,1235 XYZ,3

Now when I read the file in the second row the data 0001234 comes out to be 1234, but I need it to be as 0001234 and don't want any data
to be modified. May be Microsoft Driver doing something. Any work arrounds. Following is a code snippet>

c = DriverManager.getConnection("jdbc:odbc:;Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=.;Extensions=csv,txn");			
stmt = c.createStatement();
String sql = "select * from " + filelocation;
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
while(rs.next())
{				
   String Number = rs.getString("Number");
   String Name = rs.getString("Name");
   String Address = rs.getString("Addr");
   String Count = rs.getString("Count");
}

Any help or workarround is really appreciated. Thanks

 

[sedj]

Looks like it is the driver ... why not just read the file using a FileInputStream or BufferedReader rather than through a driver ?

Click here to learn Ways to help with Tsunami Relief
--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[idarke]

I'm pretty sure that Microsoft considers a csv file to be a type of Excel format - in which case it would convert the 00001234 to a number.

If you can, you might try putting quotes around each of the elements in the file so the driver treats them as text, like this:

"00001234","Test","1235 XYZ","3

 

[abc73]

Thanks

 

[pzepernick]

I have an Java API on sourceforge for reading delimited and fixed length text files, that may be able to help. Check it out at:

http://www.sourceforge.net/projects/pzfilereader

Paul Zepernick