AnsweredAssumed Answered

Trim Question

Question asked by dean33616 on Jan 25, 2018
Latest reply on Jan 25, 2018 by philmodjunk

We have a database with a Practice Name field. Our users often copy and paste data into this field that they capture from websites so we end up with leading and trailing spaces in the field. What is the recommended way to trim the leading and trailing spaces out of the Practice Name field? Is there a recommended approach for cleaning up our entire database of 30,000 records?

Outcomes