Re: Quoting text strings for SCV output

If you were to use Python, you could use the xlsxwriter package and build
an actual Excel file and not worry about CSV.

First, install xlsxwriter:

$ pip3 install xlswriter

Then use something like this:

from xlsxwriter import Workbook
import ibm_db_dbi as db2

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

query = "select * from qiws.qcustcdt"
filename = "qcustcdt.xlsx"

with Workbook(filename) as workbook:
cur.execute(query)
worksheet = workbook.add_worksheet()

headers = [descr[0] for descr in cur.description]
worksheet.write_row('A1', headers)

for rownum, row in enumerate(cur, start=1):
worksheet.write_row(rownum, 0, row)


"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 11/16/2016
09:16:34 AM:

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

On Wed, Nov 16, 2016 at 8:11 AM, Don Brown <DBrown@xxxxxxxxxx> wrote:

I have a requirement to produce a csv file with all text strings

double

quoted.

Can you guarantee that the textual data doesn't itself contain
double-quotes? If not, then how are they supposed to be handled?

My first question is does anyone have a method to generate an excel
spreadsheet either .xls or .xlsx that can then be saved as a csv file

that

will include double quotes around text cells ?

There isn't a way to create such a CSV via Excel. If Excel is
involved, it will only put quotes around text fields that contain
characters which need to be escaped (the ones I know of are comma,
double-quote, and newline).

Appreciate any suggestions

First and foremost, I personally think the most important thing is to
really understand the requirements. For example, why do you need the
double-quotes around all text fields, and what happens if the field
itself contains a double-quote? (These are only some of the questions
I would have. I would definitely want to know more.) And yes, I'm sure
these requirements are imposed on you by some third party, but I would
want to know from them how exactly they are processing the CSV.

If you truly have a thorough understanding of the exact requirements,
and all the possible corner cases and pitfalls, then you're ready to
write your output directly to IFS as a stream file in your desired
format.

I know I'm shoehorning this in, but if you're willing to use Python,
that would make things much easier. You could either use Python as a
soup-to-nuts solution (including pulling together the data, doing the
calculations, and outputting to CSV), or just as a postprocessor
(accepting either an Excel workbook or an Excel-generated CSV, and
writing out the desired variant of CSV). I imagine there are several
other technologies that are "comparably easy" as Python for this task,
but I have not used them and thus cannot vouch for them.

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.