php - export string with both double quotes and comma into csv format

Question

I know how to handle string with comma into csv, and string with double quote into csv,

but if a string with both comma and double quote, how to convert it ?

like:

Seminar on "Changing Myanmar: Institutions, Personalities and Expectations" 10 Feb 2012;

by default I added " " to the string, so it can convert to csv file with comma,

but if this string also contains "", then the field separate into two fields in csv.

I tried this:

"Seminar on """Changing Myanmar: Institutions, Personalities and Expectations""" 10 Feb 2012"

but it is wrong...

Your data is ambiguous. You won't be able to reliably decode from it without some knowledge about the fields. If you can re-export your file, use an escape character, such as a backslash. — Brad
– Brad, Commented Feb 4, 2013 at 5:25

napolux · Accepted Answer · 2013-02-04 06:08:48Z

1

I think that using fputcsv() is the best way to avoid any problem.

answered Feb 4, 2013 at 6:08

napolux

16.2k9 gold badges55 silver badges72 bronze badges

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

1 Comment

mickmackusa Over a year ago

This un-implemented hint could have been a comment under the question instead of an answer.

web-nomad · Accepted Answer · 2013-02-04 05:35:31Z

0

This works:

<?php
@unlink( 'test.csv' );
$fp = fopen( 'test.csv', 'w' );

$text = '"Changing Myanmar: Institutions, Personalities and Expectations"';

fwrite( $fp, '"'. str_replace( '"', '""', $text ) . '", "test"' . "\n" );

fclose( $fp );
?>

Reading from this csv file:

$fp = fopen( 'test.csv', 'r' );

while( ( $data = fgetcsv( $fp, '', ',' ) ) !== false ) {
    echo $data[0];
}

fclose( $fp );

Output - "Changing Myanmar: Institutions, Personalities and Expectations"

Hope this helps.

answered Feb 4, 2013 at 5:35

web-nomad

6,0133 gold badges37 silver badges49 bronze badges

Collectives™ on Stack Overflow

php - export string with both double quotes and comma into csv format

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related