You may want to speak with them and tell them not to fix it. If they notice it,
then they might think that it's a problem that should be corrected and then
you'll be distressed again.

Dallman Ross wrote:

In , Dallman Ross <dman@localhost.
spake thusly:

Oh, brother; I see. The jerks inserted a blank space in front
now in all the columns in the CSV file. I'm not sure yet what
the best way to handle this is -- I'm not wanting to massage the
data I download and import.

It's taking a bit of work, but now I've mostly fixed things via
a new data query and the TRIM function. I still think it was
stupid of the broker's people to suddenly insert leading spaces
inside CSV fields. This is right out of the file by way of example:

Description,Quantity,Date Acquired,Purchase Price,...
" ADVANCED MICRO DEVICES INC"," 90.0000"," 6/08/06"," 27.42",...

Dallman

--

Dave Peterson