English

How To: Trim leading and trailing spaces from string field values

Summary

Extra spaces at the beginning or end of string field values prevent operations such as joining, linking, and geocoding on tables from working correctly. You can remove these spaces by applying the Trim request in the field calculator.

Procedure

  1. Open the table and click Start Editing if necessary.
  2. Select the string field you want to trim.
  3. Click the Field Calculator button.
  4. Double-click the field name to be trimmed from the Fields list.
  5. Set the Type to String.
  6. Scroll down the Requests list and double click Trim.
    The final expression should look similar to this:
    Code:
    [Trmfld].Trim 
  7. Click OK
  8. Click Table > Stop Editing and choose to save the edits.