RE: Quoting text strings for SCV output

[Roger Harman <roger.harman@xxxxxxxxxxx>]

There are a jillion places to start.  Here's one...
https://docs.python.org/3/tutorial/


Load it on your PC or Mac and get started...
https://www.python.org/downloads/release/python-352/


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Brown
Sent: Wednesday, November 16, 2016 3:33 PM
To: Midrange Systems Technical Discussion
Subject: Re: Quoting text strings for SCV output

Never being too old to learn something new but I must admit learning new 
stuff seems to be getting harder.

If you had an example of the Python it would be appreciated - may not get 
to play with it immediately but gives me another reason to try.

Thanks


Don Brown

 



From:   John Yeung <gallium.arsenide@xxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   17/11/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 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.