|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.