Write a comma in a CSV File with PHP

Question

i am sending a csv file as a header and i want to use a comma (not to seperate, just to use). how would i do that? i'm using PHP and i can not use fputcsv because i'm sending it as a header.

jjmontes · Accepted Answer · 2012-01-04 16:52:19Z

14

Just use '"'.$value.'"' around it and it will be fine.

edited Jan 4, 2012 at 16:52

jjmontes

27.2k5 gold badges47 silver badges53 bronze badges

answered Sep 25, 2011 at 14:14

Ameer

7811 gold badge6 silver badges19 bronze badges

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

1 Comment

ontrack Over a year ago

When adding quotes around a field you'll also have to remember to escape quotes in the field! Usr str_replace for that.

Gordon · Accepted Answer · 2011-09-25 14:44:49Z

9

Either write the CSV to file first and then send it via readfile or write it to the output stream directly:

fputcsv(
    fopen('php://output', 'w+'),
    array(
        'Some text',
        'Some text with commas ,,,,,',
        'Other text'
    )
);

which will then print

"Some text","Some text with commas ,,,,,","Other text"

Note that fputcsv will also allow you to change delimiters and enclosures, so in addition to just wrapping the value in quotes you can also just change the delimiter to, for instance, a semicolon.

See the PHP Manual on supported wrappers in fopen:

http://php.net/manual/en/wrappers.php.php

edited Sep 25, 2011 at 14:44

answered Sep 25, 2011 at 13:46

Gordon

318k76 gold badges548 silver badges566 bronze badges

Collectives™ on Stack Overflow

Write a comma in a CSV File with PHP

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related