Java, fill CSV File with integer casted to String

Question

I have an Integer value that is to long to be exported and displayed correctly in a CSV file.

the value is diaplyed like this:

1,13364E+12

instead of something like this:

08136677950770

I use BufferedWriter to write the file, and the code looks like this:

writer.write(data[0].toString());
writer.write(";");

I've tried like this:

writer.write("\'"+data[0].toString()+"\'");
writer.write(";");

but it displays this:

'08136677950770'

How can I display this value without the quotes?

08136677950770

Nikolas · Accepted Answer · 2016-07-28 12:12:41Z

2

I recommend you using the BigInteger, that works with the String representation.

To get its value use simple toString() method.

BigInteger bi = new BigInteger("1234567890"); 
String str = bi.toString();

answered Jul 28, 2016 at 12:12

Nikolas

45k19 gold badges132 silver badges201 bronze badges

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

Comments

Young Emil · Accepted Answer · 2016-07-28 12:16:48Z

0

When you use microsoft excel or some application program to open the csv and it shows this way 1,13364E+12 . It doesn't mean the value has changed. It is excel that has formatted it the way it like. But the value is still the same.

You can use ordinary notepad to open it and see the actual value.

Again try changing

writer.write("\'"+data[0].toString()+"\'");

to

writer.write("\""+data[0].toString()+"\"");

OR to this if it doesn't work.

writer.write(data[0].toString()+"");

answered Jul 28, 2016 at 12:16

Young Emil

2,2763 gold badges29 silver badges39 bronze badges

Comments

Marc El Bichon · Accepted Answer · 2016-07-28 14:09:31Z

0

I've tried your solutions, but none of them worked.

I've found the solution that consist to add the simple Tab character (/t ASCII 9) at the end:

writer.write(data[0].toString()+"\t");

answered Jul 28, 2016 at 14:09

Marc El Bichon

4071 gold badge9 silver badges26 bronze badges

Collectives™ on Stack Overflow

Java, fill CSV File with integer casted to String

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related