Auto- Uncapitalize First and Last names in the database

(system) #1

When I import a batch of resumes, some folks format their resumes to have their first and last names in ALL CAPS. So, after import, their record also has their first and last name in all caps. So when I want to bulk email a group of candidates, and have their first names auto inserted into the beginning of the email, some of the first names are in ALL CAPS, which is less that ideal because that is not how one would normally address a candidate in an email, in ALL CAPS. Is there a way to auto-un-capitalize the first and last names of candidates when their resumes are imported into CATS, so the name is Steve Jones instead of STEVE JONES?