find spaces in fields and remove

[Archit3kt]

Can somebody show me a script to search a field in all records, look for extra space at the end of the value, and delete it?

In our company's contact management dbase, many of the users accidentally add a space at the end of a company name, and then the company appears twice on value-based drop-down lists ("solar city" and "solar city ").

[comment]

You could set the field to auto-enter a calculated value (replacing existing value) =

Trim ( Self )

To fix already entered values, you could replace the field's content with a similar calculation. Make sure you have a backup before trying this.