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