CSV export issues

Jean-Pierre Radley appl at jpr.com
Sat Jul 1 13:44:10 PDT 2017


I am trying to generate a spreadsheet using

	export word rpt= /usr/tmp/report.csv

The filePro file is an inventory of metal parts. In the Description
field the single or double quote may show up as the conventional
abbreviation for feet or inches, e.g.:

        6" DIAL CALIPER WHITE FACE

Whenever this happens, processing goes nuts at the quote-mark: all the
fields of every record up to the next one with a quote-mark are output
on the same line of the CSV file.  If there are over 600 records between
two fP records with a quote mark, the CSV file will have a line with
over 600 columns.

I can of course use an edit to remove the quote-marks, but is there some
way to use some escape mechanism to preserve them in the CSV?

Another minor annoyance:  I wanted to define the output file from data
in the filePro input. Say field 1 is the customer number:

	f = 1 { "-" { @td; export word rpt=f
or
	f = 1 { "-" { @td; export word rpt=(f)

Neither works.

-- 
JP


More information about the Filepro-list mailing list