How to take existing records and put them into title case?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I'd like to be able to do two things:

1.Search out records where names have been put into in a field in all caps.

and 

2.Put those names into title case.  



Is there a formula that will do that?
Photo of Dan

Dan

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
You can search for records where the entire field is in uppercase using this criteria:

[field] = Upper([field])

But you have to use script to convert to title case if the field contains more than a few words. To convert a field to title case where there is only one word you can do this:

Upper(Left([field], 1)) & Lower(NotLeft([field], 1))

If you have two or three words in the field you can extend this formula using Part() but it becomes tedious quickly.

It never becomes tedious with script - script can do anything you want in a uniform way. No more special handling.