Remove spaces when writing to CSV using CSVWriter in java

Question

I am reading from table and writing to CSV file using CSVWriter in JAVA. My delimiter is 'control-A' . But one column is having spaces in comments. So how to remove that spaces from value while writing to CSV file. My code is

Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("query");
CSVWriter writer = new CSVWriter(new FileWriter(filePath + "File_writerCSV.csv"),'\u0001');
writer.writeAll(rs,false);
writer.close();

Why do you not use a delimiter that is not appearing in your data? — Dencrash
– Dencrash, Commented Sep 11, 2015 at 5:56
We can use. But that is comment column.. might be any character they will use. If any way to remove that then that is better — Mars
– Mars, Commented Sep 11, 2015 at 6:00
If the comma is not important you can always replace it using string.replace(',', ' '). But I think you should rather use an delimiter like $$$$$ — Dencrash
– Dencrash, Commented Sep 11, 2015 at 6:03

marthursson · Accepted Answer · 2015-09-11 06:34:07Z

1

If you are using OpenCsv this should not be a problem: it will automatically quote values as necessary, i.e. if one of the values you write is some,comment OpenCsv will actually write "some,comment" (enclosed in qoutes). All standard csv; nothing you have to worry about.

answered Sep 11, 2015 at 6:34

marthursson

3,3001 gold badge22 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abhijeet Kale · Accepted Answer · 2015-09-11 06:32:34Z

0

other way is if a value contains ',' character put that value in quotes. of example if value is BMW,AUDI,MERc --> convert it into "BMW,AUDI,MERC". so it will be considered 1 entity.

String s = "as,as,as";
        if(s.contains(","))
        {
            s="\""+s+"\"";
        }

answered Sep 11, 2015 at 6:32

Abhijeet Kale

1,7141 gold badge17 silver badges36 bronze badges

1 Comment

marthursson Over a year ago

The library will automatically do this if needed.

Collectives™ on Stack Overflow

Remove spaces when writing to CSV using CSVWriter in java

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related