cancel
Showing results for 
Search instead for 
Did you mean: 

List of Account Names - how to exclude records in ProperCase

bhare1357
Frequent Contributor

Hi all - I have a list of account names. Some of them are in ALL CAPS and some are in "proper case". I plan on running a Modify scenario to fix those in all caps and bring them down to proper case. Some of these are fine the way they are (already proper case)

My question is - is there a way to exclude those in proper case or only pull those in all caps using Demand Tools? this would save me about 12k records to go through 🙂

Any thoughts welcome - thanks as always 🙂

1 REPLY 1

AnthonyValidity
Validity Team Member
Validity Team Member

Hi @bhare1357 ,

Currently there is no way to add a condition in the Record Selection Criteria that would consider upper or lower case characters.  This would be a great feature request you can add by following this article

The great news is Modify will ignore any records where the field is already formatted correctly, but it will look through them all in your preview screen.

Regards,

Anthony Lardiere Jr
Senior Customer Success Manager