Re: issue with csv module (subject module name spelling correction, too)

Path	csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!not-for-mail
From	"Martin A. Brown" <martin@linux-ip.net>
Newsgroups	comp.lang.python
Subject	Re: issue with csv module (subject module name spelling correction, too)
Date	Fri, 11 Mar 2016 13:20:44 -0800
Lines	36
Message-ID	<mailman.7.1457731250.12893.python-list@python.org> (permalink)
References	<nbv71v$1fj8$1@gioia.aioe.org> <nbvb0s$1nps$1@gioia.aioe.org>
Mime-Version	1.0
Content-Type	text/plain; charset=US-ASCII
X-Trace	news.uni-berlin.de sVhQQ2srrpVkeAtFn86PPQbImvBE7xCHsdrQ531udf7A==
Return-Path	<martin@linux-ip.net>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.014
X-Spam-Evidence	'H': 0.97; 'S': 0.00; 'variant': 0.07; 'cc:addr :python-list': 0.09; 'csv': 0.09; 'subject:module': 0.09; 'tuning': 0.09; 'from:addr:martin': 0.16; 'instance:': 0.16; 'luck,': 0.16; "module's": 0.16; 'received:hsd1.or.comcast.net': 0.16; 'received:io': 0.16; 'received:or.comcast.net': 0.16; 'received:psf.io': 0.16; 'subject:issue': 0.16; 'subject:subject': 0.16; 'subject:too': 0.16; 'cc:20': 0.20; 'cc:addr:python.org': 0.20; 'martin': 0.22; 'cc:no real name:20': 0.22; 'import': 0.24; 'header:In-Reply-To:1': 0.24; 'module': 0.25; 'parameters': 0.27; 'turns': 0.27; 'received:24': 0.28; 'preserve': 0.29; 'quoting': 0.29; 'skip:q 20': 0.29; "i'd": 0.31; 'url:python': 0.33; 'control,': 0.33; 'received:comcast.net': 0.33; 'skip:d 20': 0.34; 'url:org': 0.36; 'possible': 0.36; 'url:library': 0.36; 'subject:: ': 0.37; 'charset:us-ascii': 0.37; 'data': 0.39; 'subject:with': 0.40; 'url:3': 0.60; 'your': 0.60; 'received:network': 0.61; 'more': 0.63; 'readers': 0.66; 'touch': 0.66; 'dialect': 0.84; 'subject:, \n ': 0.84; 'surprised,': 0.84; 'technique': 0.93; 'to:addr:hotmail.com': 0.98
X-X-Sender	mabrown@macron.wonderfrog.net
In-Reply-To	<nbvb0s$1nps$1@gioia.aioe.org>
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.21
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Xref	csiph.com comp.lang.python:104641

Show key headers only | View raw

Good afternoon Fillmore,

>>>> import csv
>>>> s = '"Please preserve my doublequotes"\ttext1\ttext2'
>>>> reader = csv.reader([s], delimiter='\t')

> How do I instruct the reader to preserve my doublequotes?

Change the quoting used by the dialect on the csv reader instance:

  reader = csv.reader([s], delimiter='\t', quoting=csv.QUOTE_NONE)

You can use the same technique for the writer.

If you cannot create your particular (required) variant of csv by 
tuning the available parameters in the csv module's dialect control, 
I'd be a touch surprised, but, it is possible that your other csv
readers and writers are more finicky.

Did you see the parameters that are available to you for tuning how 
the csv module turns your csv data into records?

  https://docs.python.org/3/library/csv.html#dialects-and-formatting-parameters

Judging from your example, you definitely want to use 
quoting=csv.QUOTE_NONE, because you don't want the module to do much 
more than split('\t').

Good luck,

-Martin

-- 
Martin A. Brown
http://linux-ip.net/

Thread

issue with CVS module Fillmore <fillmore_remove@hotmail.com> - 2016-03-11 14:41 -0500
  Re: issue with CVS module Joel Goldstick <joel.goldstick@gmail.com> - 2016-03-11 15:05 -0500
    Re: issue with CVS module Fillmore <fillmore_remove@hotmail.com> - 2016-03-11 15:32 -0500
      Re: issue with CVS module mm0fmf <none@invalid.com> - 2016-03-11 21:04 +0000
      Re: issue with CVS module Ben Finney <ben+python@benfinney.id.au> - 2016-03-12 08:13 +1100
  Re: issue with CVS module Fillmore <fillmore_remove@hotmail.com> - 2016-03-11 15:49 -0500
    Re: issue with CVS module MRAB <python@mrabarnett.plus.com> - 2016-03-11 21:14 +0000
      Re: issue with CVS module Fillmore <fillmore_remove@hotmail.com> - 2016-03-11 16:23 -0500
    Re: issue with csv module (subject module name spelling correction, too) "Martin A. Brown" <martin@linux-ip.net> - 2016-03-11 13:20 -0800
  Re: issue with CVS module Mark Lawrence <breamoreboy@yahoo.co.uk> - 2016-03-11 21:15 +0000
    Re: issue with CVS module Fillmore <fillmore_remove@hotmail.com> - 2016-03-11 16:26 -0500
      Re: issue with CVS module alister <alister.ware@ntlworld.com> - 2016-03-12 09:49 +0000
  Re: issue with CVS module Fillmore <fillmore_remove@hotmail.com> - 2016-03-11 16:29 -0500

csiph-web