How do I remove blank spaces in a text field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large access file that has a text field with data in it of various
length that some how got spaces of various lengths at the very end of each
entry. I need to remove those spaces. What is the easiest way to do a query
to remove those spaces? Thank you for any help.
 
So long as there are no space at the beginning of the text that you want to
keep, I'd use the TRIM function in an update query, or a SELECT query using
the TRIM function that is then used elsewhere...
 
Thank you David, that worked. For anyone wondering the exact steps I took
they are as follows:

1. Open up the Access file
2. Go to Queries
3. Select Create query in Design view
4. Select the proper table
5. Select the field you want to have the extra spaces removed from
6. On your top menu bar select Query Type and choose Update Query
7. Below in the Update To field type in Trim[Field Name]
8. Click on Run in the top menu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Subtract text after the third space and before the fourth (from between spaces) 3
Removing excess spaces in data 7
Filter Records with a space at the beginning 3
Split column contents (de-concantenate) 7
Removing multiple spaces 6
Removing extra spacing in imported text 6
Remove leading spaces 4
remove leading space in field in Access 2

Back
Top