Re: creating a list from a inconsistent text file

2008-05-02 Thread Kam-Hung Soh
On Fri, 02 May 2008 23:47:11 +1000, Jetus <[EMAIL PROTECTED]> wrote: On May 2, 7:19 am, Marc 'BlackJack' Rintsch <[EMAIL PROTECTED]> wrote: On Fri, 02 May 2008 04:14:47 -0700, Jetus wrote: > I have a comma delimited file that is separated by comma's, and then > sometimes by "," > c:\temp\05-06

Re: creating a list from a inconsistent text file

2008-05-02 Thread Diez B. Roggisch
Jetus schrieb: On May 2, 7:19 am, Marc 'BlackJack' Rintsch <[EMAIL PROTECTED]> wrote: On Fri, 02 May 2008 04:14:47 -0700, Jetus wrote: I have a comma delimited file that is separated by comma's, and then sometimes by "," c:\temp\05-06-08\Sale1,659 CECIL,"659 CECIL,40211", 1,659,CECIL,AVENUE,LOU

Re: creating a list from a inconsistent text file

2008-05-02 Thread Mike Kent
On May 2, 9:47 am, Jetus <[EMAIL PROTECTED]> wrote: > Hello Marc; > Thanks for the input! I am worried about the comma in the "" data > items, how do I tell Python to look for the "" data first, then use > the comma separator? Marc has already given you the correct answer. You really should read

Re: creating a list from a inconsistent text file

2008-05-02 Thread Jetus
On May 2, 7:19 am, Marc 'BlackJack' Rintsch <[EMAIL PROTECTED]> wrote: > On Fri, 02 May 2008 04:14:47 -0700, Jetus wrote: > > I have a comma delimited file that is separated by comma's, and then > > sometimes by "," > > > c:\temp\05-06-08\Sale1,659 CECIL,"659 CECIL,40211", > > 1,659,CECIL,AVENUE,LO

Re: creating a list from a inconsistent text file

2008-05-02 Thread Marc 'BlackJack' Rintsch
On Fri, 02 May 2008 04:14:47 -0700, Jetus wrote: > I have a comma delimited file that is separated by comma's, and then > sometimes by "," > > c:\temp\05-06-08\Sale1,659 CECIL,"659 CECIL,40211", > 1,659,CECIL,AVENUE,LOUISVILLE,40211,"$65,276.78 " > c:\temp\05-06-08\Sale2,637 SOUTH 27TH,"637 SOUTH

creating a list from a inconsistent text file

2008-05-02 Thread Jetus
I have a comma delimited file that is separated by comma's, and then sometimes by "," c:\temp\05-06-08\Sale1,659 CECIL,"659 CECIL,40211", 1,659,CECIL,AVENUE,LOUISVILLE,40211,"$65,276.78 " c:\temp\05-06-08\Sale2,637 SOUTH 27TH,"637 SOUTH 27TH,40211", 2,637,SOUTH 27TH,STREET,LOUISVILLE,40211,"$45,45