Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
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.
ID
91
Category
User Experience
Author

Matt Warner
Date Created
3/20/2007 11:01:28 AM
Date Updated
3/20/2007 11:01:28 AM
Status
New Idea
Score
10
Promoted By
Matt Warner
Feedback
 
Back to Search Results