Description: This solution discusses the Proper Casing function as it related to patrynomic prefixes
The Proper Case function automatically capitalizes the first letter of every word in a field.
It also attempts to properly capitalize fields containing common patrynomic prefixes (ex: McDonald). However, there are limits to what can and cannot be automatically proper cased. When a clear prefix, such as Mc or O' is used, it is a safe assumption to capitalize the first letter after these prefixes. Other prefixes, such as Mac or De cannot be safely assumed to capitalize the first letter after, because these also are commonly at the beginning of non-prefixed names, such as Mackenzie or Dennis. In these cases, the safest route is to only capitalize the first letter.
Incoming data without Proper Case function applied:
Incoming data with Proper Case function applied: