Need Help Trimming Field!!

[emarchant]

I have a table that the user will copy/paste into the DB. The file they are copy/pasting is given to them by a customer, and format cannot be changed.



I am trying to create a query that will trim all the blank spaces from a field (VPN) so that I can check that field against our master data. Trim() and RTrim() are still leaving a lot of the blank spaces, causing errors.

What else can I do?!?!?!?
Please help!!!

Thank you!!!

[weekend00]

trim should get rid of all spaces both in the front and in the rear (not in the middle).

[emarchant]

It doesn't work though... I put it in a query as Trim(VPN), and it returns the exact same entries with spaces that I had before!

[weekend00]

maybe that is not spaces, but some special characters instead?

[emarchant]

If that were the case, how would I know and how would I get rid of them??

Thanks for the help!

[RuralGuy]

Does you application compile without any errors? Do you have any bogus MISSING references? Something is not right with your system. Try *importing* your db into a fresh, new db and see if the problem follows: http://www.btabdevelopment.com/ts/impnew

[emarchant]

This did not work either. I am getting the same result. I am thinking that the characters are some kind of special character... but I don't know how to get rid of them!!!

Any other ideas??

[RuralGuy]

Do you have leading "spaces" that will not go away? If so then try using Asc() on the string to see the decimal value of the 1st character. You could then use Replace() to eliminate them.