CSV export issues

[Bill Campbell]

On Sat, Jul 01, 2017, Jean-Pierre Radley via Filepro-list wrote:
>I am trying to generate a spreadsheet using
>
>	export word rpt= /usr/tmp/report.csv
>
As others have pointed out, CSV files have problems dealing with
quotes, and not all CSVs are created equally depending on the
spreadsheet program.

I've found that using tab-delimiters instead of commas tends to
have fewer issues as tabs aren't generally found in ascii fields,
and are readily accepted by spreadsheets.

My most frequent use is exporting data from my Unify based
accounting software to LibreOffice Calc from SCO OpenServer to
CentOS Linux where I avoid the issue by using a MySQL table as
the transfer agent avoiding any issues with data types.

Bill
-- 
INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
Voice:          (206) 236-1676  Mercer Island, WA 98040-0820
Fax:            (206) 232-9186  Skype: jwccsllc (206) 855-5792

Foreign aid might be defined as a transfer from poor people in rich
countries to rich people in poor countries -- Douglas Casey