CF & EXCEL

[rynomet]

im querying an excel file which contains data that has trailing spaces. when i
output the value of a cell, it is always longer than what it should be, even
after i try to remove the spaces (replace,trim). how do you remove trailing
spaces when querying data? it seems like a hassel having to do it in excel.
neither of the 3 have worked: select rtrim(cell) from file trim(cell)
replacenocase(cell,' ','','all') thanks ryan

[VillageX]

If I am understanding the question correctly, the answer is that has always worked for me is trim(queryfield) surrounded by pound signs.

[rynomet]

the trim feature has always worked for me too, however its not working for this
excel file. when i open the excel file, i can see the trailing spaces (well not
see them visually, but i can tell they are there because the cursor is far away
from the last letter). the user that created the file did a cust and paste
routine from an html doc. is it possible that the trailing spaces are somehow
reading like a normal character? i cant even trim them in excel using the excel
trim function!

[VillageX]

I guess it is possible they were put into the database with spaces and are
being interpreted as regular characters; but I've never had that happen to me.
It seems odd that replace wouldn't work either.