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