Dropping .00's on export word command
Mike Schwartz
mike.appleton.wi at sbcglobal.net
Tue Jun 20 08:03:16 PDT 2006
> > I've viewed the raw output file in a word processor to make sure
> > that the ".00"'s are really not in the output file and are not being
> > cut off by Excel. I am running filePro 5.0.14 on SCO Open Server,
> > but I believe this has been the case for all versions of filePro.
> [...]
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"...
Thanks,
Mike
More information about the Filepro-list
mailing list