0's are truncate while write in to an csv using php function

Question

I have try to write data to csv using the php function.

But the 0's are truncate while write in to an csv.

$data = array ( 'aaa,bbb,ccc,dddd', '000123,456,789','"aaa","bbb"');

$fp = fopen('data.csv', 'w');

foreach($data as $line)
{
  $val = explode(",",$line);
  fputcsv($fp, $val);
} 

fclose($fp);

I think your application removes them, not your code. Excel for instance, attempts to recognize data types and parse them the way it suits best. — Wesley van Opdorp
– Wesley van Opdorp, Commented Jul 28, 2011 at 11:00
It might help to treat the numbers as strings: '"000123","456","789"' — JJJ
– JJJ, Commented Jul 28, 2011 at 11:03
I try this '"000123","456","789"', but the Quotes are displayed in the excel cell... — Manikandan Thangaraj
– Manikandan Thangaraj, Commented Jul 28, 2011 at 11:50

Luke Wenke · Accepted Answer · 2017-08-04 05:03:37Z

3

if you are trying to open csv in excel or open office, it will truncate leading zeros. when u construct the string with "\t" before zero to avoid 0 truncation

edited Aug 4, 2017 at 5:03

Luke Wenke

1,1462 gold badges24 silver badges45 bronze badges

answered Aug 2, 2011 at 18:03

Rajasekar Gunasekaran

1,8393 gold badges27 silver badges43 bronze badges

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

Comments

Jeremy · Accepted Answer · 2011-07-28 11:05:20Z

2

I think Excel has treated it as a number and omitted the 0.

You may try to do this:

fputcsv ($fp, "='".$val."'");

See if it works

answered Jul 28, 2011 at 11:05

Jeremy

4,9752 gold badges21 silver badges26 bronze badges

1 Comment

Hosam Aly Over a year ago

This is susceptible to errors if the value contains quote characters.

James C · Accepted Answer · 2011-07-28 11:04:22Z

1

You could find that it's Excel, etc that's eating the 0 characters (you can test this out by opening the csv file in notepad (or whatever your favourite text editor is) and seeing if they're there.

If that's not the case then try using the following line:

fputcsv($fp, (string) $val);

Just in case the variable is somehow being cast to an integer somewhere.

answered Jul 28, 2011 at 11:04

James C

14.2k1 gold badge37 silver badges45 bronze badges

Collectives™ on Stack Overflow

0's are truncate while write in to an csv using php function

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related