Re: Problem in splitting a string

From: Paul McGuire (ptmcg_at_austin.rr._bogus_.com)
Date: 07/22/04


Date: Thu, 22 Jul 2004 19:49:20 GMT


"Angelo Secchi" <secchi@sssup.it> wrote in message
news:mailman.719.1090519759.5135.python-list@python.org...
>
> Hi,
> I have string of numbers and words like
>
> ',,,,,,23,,,asd,,,,,"name,surname",,,,,,,\n'
>
> and I would like to split (I'm using string.split()) it using comma as
> separator but I do not want to split in two also the "name,surname"
> field. In other word I would like python in separating fields to skip
> that particular comma.
>
> How can I do that?
>
> Thanks in advance
>
> Angelo
>
>
>
> --
> ========================================================
> Angelo Secchi PGP Key ID:EA280337
> ========================================================
> Current Position:
> Graduate Fellow Scuola Superiore S.Anna
> Piazza Martiri della Liberta' 33, Pisa, 56127 Italy
> ph.: +39 050 883365
> email: secchi@sssup.it www.sssup.it/~secchi/
> ========================================================

Using pyparsing's commaSeparatedList (designed specifically to handle this
case):

from pyparsing import commaSeparatedList
testdata = ',,,,,,23,,,asd,,,,,"name,surname",,,,,,,\n'
print commaSeparatedList.parseString( testdata )

Gives:
['', '', '', '', '', '', '23', '', '', 'asd', '', '', '', '',
'"name,surname"', '', '', '', '', '', '', '']

Download pyparsing at http://pyparsing.sourceforge.net.

-- Paul



Relevant Pages

  • Re: Problem in splitting a string
    ... Byron ... Angelo Secchi wrote: ... In other word I would like python in separating fields to skip ... > that particular comma. ...
    (comp.lang.python)
  • Re: Problem in splitting a string
    ... Angelo Secchi wrote: ... > I have string of numbers and words like ... In other word I would like python in separating fields to skip ... > that particular comma. ...
    (comp.lang.python)
  • Re: Problem in splitting a string
    ... Angelo Secchi wrote: ... > that particular comma. ... You may want to look at regular expressions, but in the example you gave, ... you just have to split the string at the quotation marks, ...
    (comp.lang.python)
  • Re: Problem in splitting a string
    ... Angelo Secchi wrote: ... >I have string of numbers and words like ... >that particular comma. ... working on a DSV module that would handle all of this stuff, ...
    (comp.lang.python)