Export question

[Cindy Youngman]

Hi all,

Long time no talk.  I’ve got an export question for all you gurus out there.

BTW - running 4.8 on SCO Openserver V

I've got a process that exports to 3 different files within the same
process.  My export process in a gosub as follows:

setexp þ If: xf="1"
þ
       Then: fn="/arc/dataexports/neprice"
þ
 46  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       þ If: xf="2"
þ
       Then: fn="/arc/dataexports/necolors"
þ
 47  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       þ If: xf="5"
þ
       Then: fn="/arc/dataexports/necolco"
þ
49  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       þ If:
þ
       Then: export ASCII out=(fn) f=, o=" c=" r=\n  -a
þ
 50  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       þ If:
þ
       Then: return
þ


I have a process in the beginning for the process to clears my 3 files and I
am using an append flag on the export.  After each line exported I am doing
a "write" and a "close" since I am using 3 separate files for the same
record.  This all works great HOWEVER my first file contains 50 fields and
my second 2 files only 6-8 fields.  When the files are created, I get the
extra "","","","" etc on the end of each line up to 50 for my smaller files.


My question is:

Is there some way to stop this from happening?  Is there a way of resetting
between each export so the structure is not extended to the same length as
my first file?

Thanks to all in advance,
Cindy Youngman
System Developer
Creative Touch Interiors (Old Floors, Inc.)
cyoungman at sc.rr.com
Office: (803) 736-5329
Cell: (803) 422-8286