How do I TRIM a field in existing fields....?

  • Thread starter Thread starter Kelvin Beaton
  • Start date Start date
K

Kelvin Beaton

I didn't realize when I imported some data into my database that there were
a bunch of spaces after all the data.

I know that I can do a RTRIM the data in a query, but I don't want to have
to remember every time I create a query to TRIM it.

Do I have to use a query and make a temp table and then delete the data from
my original table and then put the data back in from my temp table.
I can do this, but wanted to know if there is a better way.

Thanks

Kelvin
 
Kelvin

A standard approach to importing (and "cleaning") data is to import/append
to a temporary table, then use queries to parse the data into your
permanent, well-normalized tables. In this process, the Trim() function
(which would take care of both leading and trailing spaces) can easily be
added.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks Jeff

I get that I did this backwards, but was hoping there was something I could
to with my mess now.

Is there anything like search and replace?
I jext need to delete all the spaces in each field.......

Thanks

Kelvin
 
Back
Top