Writing CSV file

[Mike Jeya]

Hi,
we need to create the CSV file . problem is some column value have comma in it, because of which the file format is changed.
can you please let me know the procedure to take care of comma values too,


RandomAccessFile raf = new RandomAccessFile(file, "rw");
raf.seek(file.length());
raf.writeBytes(new StringBuffer(strUID+","
+strFirstName+","+strLastName+","+strMail+","+strTelephone+","+groupName+"\n").toString());
raf.close();

please advise me.....

[Ulf Dittmer]

You need to enclose all cells contents by quotes, so that they look like this:

"first cell","second,cell,containing,commas","third cell"

There are other characters that need to be treated especially (like doubles quotes and newlines), so you may be better off using one of the readily available CSV libraries. The http://faq.javaranch.com/java/AccessingFileFormats lists several.

[Rajasekhar Pentakota]

import java.io.*;
public class RAF{
 
public static void main(String[] args) {
try
{
File f=new File("C:\\FileSample\\RAF.txt");
RandomAccessFile raf=new RandomAccessFile(f,"rw");
String s="One,Two,\"Two1,Two2\",Three";
raf.writeBytes(s);
raf.close();
}
catch(Exception ex)
{System.out.println(ex.getMessage());}
}
}