Find uppercase and lowercase in a field - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Tom BarberTom Barber 

Find uppercase and lowercase in a field

A bunch of garbage Contacts were uploaded to Salesforce over time with Salesforce for Outlook. I am trying to find them all and delete them. The key is they virtually all have proper case first and last names ("Tom Barber" instead of "TOM BARBER", like for all other records). Try as I might, I cannot craft a good way to find all these records using a formula field. Looking for ideas.
Best Answer chosen by Tom Barber
Andrew GillanAndrew Gillan
Hi Tom

Quick thought, create a Checkbox via Formula 
IF(UPPER(Name) = Name), 1,0)

The search for all teh checkboxes with 0 

Regards
Andrew

All Answers

Andrew GillanAndrew Gillan
Hi Tom

Quick thought, create a Checkbox via Formula 
IF(UPPER(Name) = Name), 1,0)

The search for all teh checkboxes with 0 

Regards
Andrew
This was selected as the best answer
Tom BarberTom Barber
This is why the community is so helpful when you are "stuck". Modified it a bit and worked like a charm!
IF(
AND(
UPPER(FirstName)= FirstName,
UPPER(LastName)= LastName),
TRUE,FALSE)
Thanks Andrew!