CSV export issues

[Bob Rasmussen]

Not a full solution, but some hints:

1) The format you want is dependent on the program that will be importing 
the .CSV, as all CSV are NOT created equal.

2) Watch out for fields containing commas, also.

3) Try wrapping alpha fields in single quotes (unless they occur in your 
data also).

On Sat, 1 Jul 2017, Jean-Pierre Radley via Filepro-list wrote:

> 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
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

Regards,
....Bob Rasmussen,   President,   Rasmussen Software, Inc.

personal e-mail: ras at anzio.com
  company e-mail: rsi at anzio.com
           voice: (US) 503-624-0360 (9:00-6:00 Pacific Time)
             fax: (US) 503-624-0760
             web: http://www.anzio.com
  street address: Rasmussen Software, Inc.
                  10240 SW Nimbus, Suite L9
                  Portland, OR  97223  USA