[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