Automatically strip leading and trailing spaces from text entries
It looks like Teamdesk is storing leading and trailing spaces in text entries if the user accidentally hit the space bar (or copy/pasted poorly - i.e. " Matt " instead of "Matt"). This causes extra spaces when text formulas are used to concatenate columns (i.e. created a full name "Mr. Matt Warner" from [Title], [First Name], and [Last Name] columns). This can also cause problems with finding records in queries. Is it possible to automatically strip these extra "empty" characters?
Right now I am periodically running queries to find these extra spaces and manually removing them, but ideally the application would not store them when the user enters them.