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