any tips to COPY INTO from a csv with whitespace around some DOUBLE fields?

here's the problem--

Unable to execute statement 'COPY 2626675 OFFSET 2 RECORDS INTO OPPR_ALL_DTL_GNRL_09302014 FROM 'C:\Users\anthonyd\AppData\Local...'.

Server says '!value '1 ' from line 1 field 51 not inserted, expecting type double'.

i could import it as VARCHAR and then CAST it back into a DOUBLE type, but i'm wondering if anyone has an easier/more clever way to import this? handling it manually would mean that i cannot use the monet.read.csv() function, so it's a bit more work. thanks!