delineating by comma where commas inside quotation marks don't count

equand at gmail.com equand at gmail.com
Thu Oct 25 04:18:21 CEST 2007


On Oct 25, 3:56 am, "Junior" <mlon... at verizon.net> wrote:
> I want to open a text file for reading and delineate it by comma.  I also
> want any data
> surrounded by quotation marks that has a comma in it, not to count the
> commas inside the
> quotation marks
>
> if the file testfile.txt contains the following;
>
> 5,Tuesday,"May is a spring month",Father's Day
> 1,Saturday,"June,July and August",Independance Day
>
> and I write the following program
>
> fname = open('testfile.txt', 'r')
> ct=1
> while ct != 3:
>     rd=(fname.readline())
>     filedata=rd.split(',')
>     print "var2=",filedata[2]
>     ct +=1
>
> fname.close
>
> filedata[2] will = "May is a spring month"; on the first pass and
>
> filedata[2] will = "June;  on the second pass
>
> How do I get filedata[2] to = "June,July and August" on the second pass
>
> and filedata[3] to = Independance Day

why not using csv?
but u would better put all strings into ""
else u can

r = open('file').read().splitlines()

for i in r:
    l1 = i.split(',',2)
    l2 = l1.pop().rsplit(',',1)
    print l1+l2




More information about the Python-list mailing list