https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/99982.aspxSat, 08 Nov 2014 03:39:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:99982pmo365.com0https://www.infopathdev.com:443/forums/thread/99982.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=99982<p><strong>Does anyone know of a&nbsp;codeless and smarter way to&nbsp;both validate and creation of actions to correct&nbsp;user input&nbsp;of Last Names (surnames) so that they are all Proper Cased capitalisation?</strong>&nbsp;&nbsp;</p><p><em>I can come up with&nbsp;a&nbsp;solution that handles most of the following conditions&nbsp;with a lot of conditions and&nbsp;pattern matching, but not for all them.&nbsp; There must be a more efficient way to handle all name types of such as the following examples:</em></p><ul><li><div style="margin-right:0px;">Brooks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em> &nbsp;-&nbsp;single word</em></div></li><li>Graham-King&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em>&nbsp; - one hyphen</em></li><li>Van Dyck&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <em>&nbsp;- with one space</em></li><li><em>Van-Der-Laan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - with two hyphens</em></li><li>Van Der Laan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em> - with two Spaces</em></li><li>O&#39;Connor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em> - with one&nbsp;apostrophe</em></li><li>MacDonald&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em>&nbsp; - &#39;Mac&#39; names&nbsp; (tough to distinguish between MacDonald and Maclean)</em></li><li>McDonald&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em> - &quot;Mc&#39; names</em></li><li><em>St. Francis&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - &quot;St.&#39; with or without the fullstop (.) names</em></li><li>Van&nbsp;der&nbsp;s&#39;Graven<em>-&nbsp;containing combinations of apostrophe, hyphen and spaces</em></li></ul><p>&nbsp;All help and comments would be greatly appreciated!!</p><p>pmo365</p>