Dropping .00's on export word command

Kenneth Brody kenbrody at bestweb.net
Tue Jun 20 11:53:02 PDT 2006


Quoting Mike Schwartz (Tue, 20 Jun 2006 10:03:16 -0500):

[...]
>      When I viewed the output .WP file with "less" on the SCO Open
> Server Box, the .00's were already missing.  (I hadn't attempted to
> FTP the file to a Windows box or open it with Excel or any other
> spreadsheet program yet.)
>
>       The data on in "less" looked like:
>
> "MAY","132"
>
> when I expected to see:
>
> "MAY","132.00"
>
>      Even worse, the final zero always seems to get dropped in filePro
> numeric fields, so the June data looked like:
>
> "JUNE","206.4"
>
>      As I mentioned, I believe this has always been the behavior with
> "export word".  It's just that I will have to write almost 1,000 "work
> around" lines in order to fix this.  I was hoping for a "magic
> bullet"...

Well, since it works for me here, and I know that filePro doesn't
strip trailing zeros from exports, it must be something specific to
your code.

If field xx contains "123.00", and you do exportfile[2]=xx, then the
export file will contain "123.00".

Can you post an actual example of code, along with the actual contents
of the relevent fields, which fails?

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