Tweet
Hello!
We wanted to share a small guide on how to find contact names that have all uppercase or lowercase characters.
The problem:
We had a lot of contacts that have entered their names like this: Steve SMITH, STEVE SMITH, steve smith, STEVE smith
To make the change automatically in the contact form would be unwise, because names are fragile. For example a Capitalization could change Steve MCDONALDS to Steve Mcdonalds, but actually their last name is McDonalds. So that wasn't the solution.
The solution:
Create a report with complex expression filters.
This checks if the name converted to lower or uppercase equals the actual name, if so it displays them so.
Couldn't find any information regarding this in the forum, so we thought to share in the Christmas spirit!
We wanted to share a small guide on how to find contact names that have all uppercase or lowercase characters.
The problem:
We had a lot of contacts that have entered their names like this: Steve SMITH, STEVE SMITH, steve smith, STEVE smith
To make the change automatically in the contact form would be unwise, because names are fragile. For example a Capitalization could change Steve MCDONALDS to Steve Mcdonalds, but actually their last name is McDonalds. So that wasn't the solution.
The solution:
Create a report with complex expression filters.
PHP Code:
EQUAL:(LOWER:(firstName), BINARY:('firstName')
PHP Code:
EQUAL:(UPPER:(firstName), BINARY:('firstName')
PHP Code:
EQUAL:(LOWER:(lastName), BINARY:('lastName')
PHP Code:
EQUAL:(UPPER:(lastName), BINARY:('lastName')
This checks if the name converted to lower or uppercase equals the actual name, if so it displays them so.
Couldn't find any information regarding this in the forum, so we thought to share in the Christmas spirit!