[PHP] CSV explode problem

[V Patel]

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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] CSV explode problem

[V Patel]

Input is a large string. We have no control over the file, so its not
coming from the file.

Any help with parsing a string to replace those comma in string?

On Wed, 23 Jun 2004 10:12:16 -0500, Matt Matijevich
<[EMAIL PROTECTED]> wrote:
> 
> 
> [snip]
> I have a csv string. But the string also contains other strings with
> commas.
> [/snip]
> 
> is the csv coming from a file?  if it is try
> http://www.php.net/manual/en/function.fgetcsv.php
> 
> if not there is some user comments on that page that might help.
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] CSV explode problem

[V Patel]

Justing,

I will be waiting for your response

Thanks,
vp

On Wed, 23 Jun 2004 08:19:55 -0700, Justin Patrin
<[EMAIL PROTECTED]> wrote:
> 
> V Patel wrote:
> 
> > Input is a large string. We have no control over the file, so its not
> > coming from the file.
> >
> > Any help with parsing a string to replace those comma in string?
> >
> > On Wed, 23 Jun 2004 10:12:16 -0500, Matt Matijevich
> > <[EMAIL PROTECTED]> wrote:
> >
> >>
> >>[snip]
> >>I have a csv string. But the string also contains other strings with
> >>commas.
> >>[/snip]
> >>
> >>is the csv coming from a file?  if it is try
> >>http://www.php.net/manual/en/function.fgetcsv.php
> >>
> >>if not there is some user comments on that page that might help.
> >>
> 
> 
> I have a function to do this. I'll send it in a few minutes (once I get
> to work).
> 
> --
> paperCrane 
> 
> 
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: CSV explode problem

[V Patel]

Thanks Justin. Works like a charm

vp

On Wed, 23 Jun 2004 08:48:57 -0700, Justin Patrin
<[EMAIL PROTECTED]> wrote:
> 
> 
> 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:
> 
>  /**
>   * 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 
> 
> 
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php