[Csv] Access Products sample

Dave Cole djc at object-craft.com.au
Fri Jan 31 03:00:05 CET 2003


>>>>> "Skip" == Skip Montanaro <skip at pobox.com> writes:

>>> The currency column in the table is actually written out with
>>> formatting ($5.66 instead of just 5.66). Note that when Excel
>>> exports this column it has a trailing space for some reason
>>> (,$5.66 ,).

Cliff> So we've actually found an application that puts an extraneous
Cliff> space around the data, and it's our primary target.  Figures.

Skip> So we just discovered we need an "access" dialect. ;-)

Not really.  Python has no concept of currency types (last time I
looked).  The '$5.66 ' thing is an artifact of converting currency to
string, not float to string.

- Dave

-- 
http://www.object-craft.com.au



More information about the Csv mailing list