CSV parsing

[Kevin Lin]

Hello all,

Anyone know of a way to call fgetcsv and fputcsv using a string rather than
a resource? (i.e.., parse a comma delimited string without writing it first
to a file.)

Thanks,
Kevin

[Ken Robinson]

Kevin Lin wrote (in part):

Anyone know of a way to call fgetcsv and fputcsv using a string rather than a resource? (i.e.., parse a comma delimited string without writing it first to a file.)

Use the explode() function:

<?
$str = explode(',','This,is,a,test');
?>

Results in the array $str with four elements:
$str[0] = 'This'
$str[1] = 'is'
$str[2] = 'a'
$str[3] = 'test'

Ken

[Kevin Lin]

Thanks for the reply, but explode doesn't handle quoted cases, e.g.:

'Item1,"Item A,ItemB","Items ""one,"" ""two,"" and ""three"""'

should get parsed to:

$array[0]='Item1'
$array[1]='Item A,Item B'
$array[2]='Items "one," "two," and "three"'
"Ken Robinson" <ke******@rbnsn.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Kevin Lin wrote (in part):

Anyone know of a way to call fgetcsv and fputcsv using a string

rather than

a resource? (i.e.., parse a comma delimited string without writing

it first

to a file.)

Use the explode() function:

<?
$str = explode(',','This,is,a,test');
?>

Results in the array $str with four elements:
$str[0] = 'This'
$str[1] = 'is'
$str[2] = 'a'
$str[3] = 'test'

Ken

[Daniel Tryba]

Kevin Lin <ke***@wx3remove4spam.com> wrote:

Thanks for the reply, but explode doesn't handle quoted cases, e.g.:

[snip]

By reading the user comments on the fgetcsv manual page one can find
http://bu.orbitel.bg/fgetcsvfromline.php. Seems the solution that you
are looking for.

[Chung Leong]

"Kevin Lin" <ke***@wx3REMOVE4SPAM.com> wrote in message
news:hdKod.557418$mD.522470@attbi_s02...

Hello all,

Anyone know of a way to call fgetcsv and fputcsv using a string rather than a resource? (i.e.., parse a comma delimited string without writing it first to a file.)

Thanks,
Kevin

Use the example class at
http://us2.php.net/manual/en/functio...r-register.php

[R. Rajesh Jeba Anbiah]

"Kevin Lin" <ke***@wx3REMOVE4SPAM.com> wrote in message news:<hdKod.557418$mD.522470@attbi_s02>...

Hello all,

Anyone know of a way to call fgetcsv and fputcsv using a string rather than
a resource? (i.e.., parse a comma delimited string without writing it first
to a file.)

IMHO, the most dependable way is to use existing fgetcsv along with
a temporary file:

<?php
function ParseCSVString($str, $delim=',')
{
//write the CSV string to a temporary file so that fgetcsv() can be
used to process...
$fp = tmpfile();
fwrite($fp, $str);
rewind($fp); //rewind to process CSV
$csv_length = strlen($str);
$data_arr = fgetcsv($fp, $csv_length, $delim);
fclose($fp); //clean up temp file
return $data_arr; //return the array
}
?>

Or may use csv_explode() found at <http://in.php.net/explode#37004>

--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com

[Kevin Lin]

This looks useful, thanks.

"Chung Leong" <ch***********@hotmail.com> wrote in message
news:bK********************@comcast.com...

"Kevin Lin" <ke***@wx3REMOVE4SPAM.com> wrote in message
news:hdKod.557418$mD.522470@attbi_s02...

Hello all,

Anyone know of a way to call fgetcsv and fputcsv using a string rather

than

a resource? (i.e.., parse a comma delimited string without writing it

first

to a file.)

Thanks,
Kevin

Use the example class at
http://us2.php.net/manual/en/functio...r-register.php