V Patel wrote:
I have a csv string. But the string also contains other strings with commas.
Explode is not working with this kind of string. For example,
1,2,3,"this string gets parsed , at the comma"
Result of explode(",",string) is 1 2 3 this string gets parsed at the comma
But what I want is 1 2 3 this string gets parsed , at the comma
I am not fluent with regular expressions. If anybody could help.
Thanks, Vp
Here's a funciton I cooked up to deal with this:
<?php
/**
* does a regular split, but also accounts for the deliminator to be within quoted fields
* for example, if called as such:
* splitQuoteFriendly(',', '0,1,2,"3,I am still 3",4');
* it will return:
* array(0 => '0',
* 1 => '1',
* 2 => '2',
* 3 => '"3,I am still 3"',
* 4 => '4');
* @param string deliminator to split by
* @param string text to split
* @param string text which surrounds quoted fields (defaults to ")
* @return array array of fields after split
*/
function splitQuoteFriendly($delim, $text, $quote = '"') {
$strictFields = explode($delim, $text);
for($sl = 0, $l = 0; $sl < sizeof($strictFields); ++$sl) {
$fields[$l] = $strictFields[$sl];
$numQuotes = 0;
while(fmod($numQuotes += substr_count($strictFields[$sl], $quote), 2) == 1) {
++$sl;
$fields[$l] .= $delim.$strictFields[$sl];
}
++$l;
}
return $fields; }
?>
Just do a splitQuoteFriendly("\n", $csv), then loop through the resulting array and do splitQuoteFriendly(',', $line).
-- paperCrane <Justin Patrin>
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
