csv.reader removing commas within quoted values

Question

I have two programs that I converted to using the csv module in Python 2.7. The first I just used csv.reader:

f=open(sys.argv[1],'r')
line=csv.reader(f)
for values in line:
  …do some stuff…

In this case commas within quoted string are removed. Another program was too complex just to read so I copied the file changing the delimiter to semi-colon:

fin=open(sys.argv[1],'rb')   
lines=csv.reader(fin)
with open('temp.csv','wb') as fout:
  w=csv.writer(fout,delimiter=';')
  w.writerows(lines)

In this case the commas inside of quoted string are preserved. I find no posts on bugs.python.org on this, so I conclude it must be me. So, anyone else experience this behavior. In the second case all elements are quoted. In the first case quotes are used only where required.

Please add a few lines of your input file to your question so we can try to recreate the problem. — martineau
– martineau, Commented Mar 29, 2015 at 18:46

Community · Accepted Answer · 2017-05-23 11:56:49Z

0

It's hard to guess without seeing a sample of your input file and the resulting output, but maybe this is related: Read CSV file with comma within fields in Python

Try csv.reader(f, skipinitialspace=True).

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Mar 29, 2015 at 19:28

michailgames

3031 gold badge2 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

csv.reader removing commas within quoted values

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related