[Csv] Access Products sample

[Cliff Wells]

On Thu, 2003-01-30 at 18:00, Dave Cole wrote:
> >>>>> "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.

I'm not sure what you mean.  A trailing space is a trailing space,
regardless of data type.  In this case, it isn't too important as the
data isn't quoted (we can just consider the space part of the data), but
it shows that extraneous spaces might not be outside the scope of our
problem.

-- 
Cliff Wells, Software Engineer
Logiplex Corporation (www.logiplex.net)
(503) 978-6726 x308  (800) 735-0555 x308