Export Header lines to a CSV file

[Chris Rendall]

Below I've included a snippet of code that shows how to get the column headers in there without losing the first record.

loop   - If:                                                                   -
       Then: export ascii rec=(hm) r=\n f=,                                    -
  3  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       - If: hd=""                                                             -
       Then: rec(1)="JOB #";rec(2)="SPOOL LETTER";hd(1,*,g)="X";goto loop

--- Chris

> -----Original Message-----
> From: Bob Simcoe [mailto:bob at midcityoffice.com]
> Sent: Monday, August 06, 2012 1:05 PM
> To: Chris Rendall
> Subject: RE: Export Header lines to a CSV file
> 
> Thank you
> 
> I have tried this technique and I lose the first record because its substituded
> with the header. I using output processing. Are you appending the csv file
> with the second export command? If so, how do you do it?
> 
> 
> Bob Simcoe
> CFO
> Mid-City Office Equipment Inc.
> A Women Business Enterprise
> P. 716.832.0138 x201
> C. 716.725.8311
> F. 716.832.0892
> Follow us on Facebook
> 
> For a Better Day at the Office
> 
> 
> -----Original Message-----
> From: filepro-list-bounces+bob=midcityoffice.com at lists.celestial.com
> [mailto:filepro-list-bounces+bob=midcityoffice.com at lists.celestial.com] On
> Behalf Of Chris Rendall
> Sent: Monday, August 06, 2012 1:53 PM
> To: Filepro-list at lists.celestial.com
> Subject: RE: Export Header lines to a CSV file
> 
> I use a global dummy variable defined as hd(1,*,g).  If hd="" then I set the
> export fields to the column headers I want them to be.  Then I set hd="X"
> and goto "export" again and then the CSV will have the column header
> names.
> 
> --- Chris
> 
> 
> 
> > -----Original Message-----
> > From: Bob Simcoe [mailto:bob at midcityoffice.com]
> > Sent: Monday, August 06, 2012 12:47 PM
> > To: Filepro-list at lists.celestial.com
> > Subject: Export Header lines to a CSV file
> >
> > Hi
> >
> > fp5.0
> > windows xp
> >
> > How can I Export column headers when Exporting to a CSV file?
> > I use:
> >
> > Export word file.csv
> >
> > file(1) = 1 ; file(2) = 2 ....etc.
> >
> > Any help would be appreciated.
> > Thank you
> > Bob Simcoe
> > CFO
> > Mid-City Office Equipment Inc.<http://www.midcityoffice.com/>
> > A Women Business Enterprise
> > P. 716.832.0138 x201
> > C. 716.725.8311
> > F. 716.832.0892
> > Follow us on Facebook<http://www.facebook.com/pages/MidCity-Office-
> > Furniture/298763689497?ref=ts>
> >
> > For a Better Day at the Office
> >
> > -------------- next part -------------- An HTML attachment was
> > scrubbed...
> > URL: http://mailman.celestial.com/pipermail/filepro-
> > list/attachments/20120806/f67e53e5/attachment.html
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list