Re: Quoting text strings for SCV output

Yep. Using the CSV module is pretty easy, here's a similar example:

import ibm_db_dbi as db2
import csv

def trim_col(s):
try:
return s.rstrip()
except AttributeError:
return s

conn = db2.connect()
cursor = conn.cursor()

query = "select cusnum, lstnam, init, cdtlmt from qiws.qcustcdt where
cdtlmt > 100"
filename = 'qcustcdt.csv'

with open(filename, 'w', newline='') as csvfile:
cursor.execute(query)

writer = csv.writer(csvfile, dialect='excel')

for row in cursor:
writer.writerow([trim_col(col) for col in row])


Note this doesn't include headers. If you want headers, you can pass an
array of headers using the fieldnames parameter to the csv.writer function
and then call writer.writeheaders():

with open(filename, 'w', newline='') as csvfile:
cursor.execute(query)

writer = csv.writer(csvfile, dialect='excel', fieldnames=[descr[0] for
descr in cur.description])
writer.writeheaders()

for row in cursor:
writer.writerow([trim_col(col) for col in row])

See https://docs.python.org/3.4/library/csv.html for more information on
how to further customize the output.

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 11/16/2016
05:16:37 PM:

From: John Yeung <gallium.arsenide@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 11/16/2016 05:17 PM
Subject: Re: Quoting text strings for SCV output
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

On Wed, Nov 16, 2016 at 5:38 PM, Roger Harman
<roger.harman@xxxxxxxxxxx> wrote:

Wouldn't the csv module be a workable solution?

Yes, which is why I injected Python into the thread. The CSV module in
Python's standard library can read or write either Excel-dialect CSV
or OP's mandatory-double-quoted-string dialect.

To minimize reworking of OP's existing tools (which generate .xls or
.xlsx) and eliminate the Excel program itself (as a .xls(x)-to-.csv
translator), Python could be used to read the workbook directly (and
quite trivially), using the xlrd third-party module.

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.