SF documentation says ProperCase(string)
Returns the specified string with the initial letter of each word capitalized.
We had some bad data collection practices existed in our previous CRM implementations in collecting names from prospects, and now have to fix these data problems at the source and meanwhile employ some scriptable ways to address the problem- like using ProperCase()
in our marketing cloud email sends.
After doing some tests of my own, found out that my AMPScript with ProperCase()
does help to solve to a large portion of our data, however, does not cater as a single solution. As for certain names like below, we do not want ProperCase()
to act.
- McKay / McDonald
- De-Wei / Marie-Helene
- O'Neill / O'Grady
- Frédéric
And this is the case with Excel as well, wanted to see if we can do something at an AMPScript level or need to pursue some custom implementation with new business rules on how to treat names in Salesforce to address this.