export
Courtney
courtney at northshoreagency.com
Fri Apr 30 05:21:16 PDT 2004
the way I do that is
| xx = " "
| xx(1,*,g) = "X";gosub init
|
| REGULAR PROCESSING
init |
| export ascii out=/tmp/order.csv r=\n f=, o=" c="
|
| out(1) = "Part #";out(2) = "Description"
|
| write out
|
| return
-----Original Message-----
From: filepro-list-bounces at lists.celestial.com
[mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of GCC
Consulting
Sent: Thursday, April 29, 2004 5:13 PM
To: 'Steve Waters'; 'Filepro List'
Subject: RE: export
-----Original Message-----
From: filepro-list-bounces at lists.celestial.com
[mailto:filepro-list-bounces at lists.celestial.com] On Behalf Of Steve Waters
Sent: Thursday, April 29, 2004 4:55 PM
To: Filepro List
Subject: export
Hello,
I am writing a export file that looks like this,
export ascii file=file.txt r=\n f=, o=" c="
file(1)=1 'part number
file(2)=2 'description
With the result of
"1234","o-ring"
"3456","nail"
Is there a way to get the Part Number and Description to lead the data like
this?
"part number","description"
"1234","o-ring"
"3456","nail"
------------------------------------------------------------------
Yes,
@rs = "1"
export ascii file=file.txt r=\n f=, o=" c="
file(1)=1 'part number
file(2)=2 'description
GOSUB do_head
File(1)=1
File(2)=2
END
Do_head
file(1)="part number"
file(2)="description"
return
This is the rough way to do this. At the first record post the header info
and
then loop back and post the next values.
Richard Kreiss
GCC Consulting
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list