On Feb 17, 9:11 pm, 7stud <[EMAIL PROTECTED]> wrote:
> On Feb 17, 7:09 pm, Christopher Barrington-Leigh
>
>
>
> <[EMAIL PROTECTED]> wrote:
> > Here is a file "test.csv"
> > number,name,description,value
> > 1,"wer","tape 2"",5
> > 1,vvv,"hoohaa",2
>
> > I want to convert it to tab-separated without those silly quotes. Note
> > in the second line that a field is 'tape 2"' , ie two inches: there is
> > a double quote in the string.
>
> > When I use csv module to read this:
>
> > import sys
> > outf=open(sys.argv[1]+'.tsv','wt')
> > import csv
> > reader=csv.reader(open(sys.argv[1], "rb"))
> > for row in reader:
> > outf.write('\t'.join([rr.strip() for rr in row]) +'\n')
>
> > it mangles it, messing up the double double-quote.
> > Can anyone help me? How do I use CSV to get it right?
> > Tjhanks!
> > c
>
> Try this:
>
> infile = open('data.txt')
> outfile = open('outfile.txt', 'w')
>
> for line in infile:
> pieces = line.strip().split(',')
>
> data = []
> for piece in pieces:
> if piece[0] == '"':
> data.append(piece[1:-2])
> else:
> data.append(piece)
>
> out_line = '%s\n' % '\t'.join(data)
> outfile.write(out_line)
Whoops. The line:
data.append(piece[1:-2])
should be:
data.append(piece[1:-1])
--
http://mail.python.org/mailman/listinfo/python-list
