Adding header to a delimited export

Jean-Pierre A. Radley appl at jpr.com
Mon Jan 10 09:28:03 PST 2005


Matthew Williams propounded (on Mon, Jan 10, 2005 at 09:06:01AM -0800):
| Currently I export UPS orders to a small delimited file, from there we
| contain headers to identify the fields.  It simply won't map field 1
| to customerID etc etc, you need the header to say "CustomerID" and
| then map it to their field.
| 
| This is where one of you comes in!  How do I append this header to my
| file?  Could it be done with a simple sub-routine so it acts before
| any records are chosen and written to the file?
| 
| Below is the line I use to export:
| 
| Then: export word plant = /upss/ups.txt -r=\n -f=, 
| Then: plant(1)=1;plant(2)=2;plant(3)=3;plant(4)=4;plant(5)=5

Insert a line that uses a dummy variable, say 'f' (for first-line):

    If: F ne "N"
  Then: plant(1)="CustomerID";plant(2)="whatever.."; other fields; F=N"


| On a side note it's been months since i've been on the list and I
| forget how it sends the mail, I would just like to setup a simple
| filter with my GMail account so I don't clog up my Inbox, are all
| messages sent from a single address or do they contain a subject with
| a static "Filepro" line somewhere?  I guess i'll find out soon enough
| as the messages start coming in.

There's no charge for separate messages on separate topics, and it's best
to have one topic per thread.  :-)

-- 
JP


More information about the Filepro-list mailing list