export

[GCC Consulting]

-----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