FW: Export question
Kenneth Brody
kenbrody at bestweb.net
Tue Sep 13 11:47:15 PDT 2005
Quoting Cindy Youngman (Tue, 13 Sep 2005 14:37:00 -0400):
[...]
> BTW - running 4.8 on SCO Openserver V
[...]
> 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?
Upgrade to 5.0.14 or later:
(All) #709
EXPORT ASCII/WORD would always export the same number of fields,
regardless of whether the fields were assigned to on each record,
even if they were only referenced in a comment.
Now, filePro will only export the number of fields as the highest-
reference field actually assigned.
For example:
If:
Then: out[1] = 1 ; out[2] = 4
If: xx = "y"
Then: out[3] = 3 ; out[4] = 4
If:
Then: ' out[5] = 5
filePro would previously always exported 5 fields. Now, if x="y"
is true, it will export 4 fields, and if false will export 2 fields.
To revert back to the old behavior, set PFEXPORTALL=ON.
--
KenBrody at BestWeb dot net spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com
More information about the Filepro-list
mailing list