php fputcsv is trims the string value while writing to file

Question

I don't know this question is asked or not. I didn't get his in suggestion.

I'm trying to write some data from database to an csv file. I'm using fputcsv function.

I'm using following code :

$fh = @fopen($fileName, 'w+');
        $writeText['sku'] = $somevalue
        $writeText['attribute_set'] = $somevalue
        $writeText['type'] = $somevalue
        $writeText['default_catalogue_link']= $somevalue
        $writeText['status'] = $somevalue
@fputcsv($fh, $writeText);
        @flush();
@fclose($fh);

Some of the values starts with zero like $writeText['sku'] is 0987. After writing to the file. I'm getting 987 in the file.

how to prevent this? I need with zero values.

Any help would be usefull. Thanks in advance.

If that doesn't work and you know that all skus are 4 digits you could use str_pad() to maintain a leading zero. Or I believe if you ensure that the values are encapsulated as strings (with quotes) in the CSV they should keep the leading zeros. — grimmdude
– grimmdude, Commented Feb 23, 2015 at 6:50
(string)somevalue is not working. Not all the values are of 4digits — Girish Hosamani
– Girish Hosamani, Commented Feb 23, 2015 at 6:53
Eek, you'll probably need to make sure the CSV has the numbers encapsulated in quotes then. — grimmdude
– grimmdude, Commented Feb 23, 2015 at 7:43
I tried $writeText['sku'] = " ".$somevalue; also, its not working. I'm not getting how to encapsulate with qoutes :-( — Girish Hosamani
– Girish Hosamani, Commented Feb 23, 2015 at 7:45

sanurah · Accepted Answer · 2015-02-23 08:11:14Z

1

Are you using Excel to open the file? Because Excel interprets it as a number. Try open and see with a text editor.

edited Feb 23, 2015 at 8:11

answered Feb 23, 2015 at 7:56

sanurah

1,1411 gold badge8 silver badges17 bronze badges

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

3 Comments

hanshenrik Over a year ago

nothing wrong with the code? check all those error supression operators! -.-

sanurah Over a year ago

sorry, i was trying to say that the data might still be in the csv even if he doesn't see it in the correct format. For an example I once tried to get the string "536775212172206080" on a csv and it was showing 5.37E+17 but the number was still there when I check with a text editor.

Girish Hosamani Over a year ago

@Sanura Yes, you are right. It's showing properly in text editor, I wanted use that file as input for another application, Its working fine. :-) Thanks

Collectives™ on Stack Overflow

php fputcsv is trims the string value while writing to file

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related