Title Casing a Hyphenated String

[madslawton3]

Hello All,

I am looking for how to title case the second name in a hyphenated string.

For example, the TitleCase(string) function converted the following: thompson, john-paul to Thompson, John-paul; however, I need the letter after the hyphen to be a capital letter as well to work with my match tool.

How can I get it to be Thompson, John-Paul?

Thank you!

[rbyrne · Accepted solution]

Not the most elegant solution but this should do the trick:

[vijaykumarmv · Accepted solution]

You can try this. If you feel there could be '$' in your data set then you may want to use some other character.

Thanks,

Vijay

[amazz24]

@vijaykumarmv  - Thanks for sharing this!  Is there a way to add a second parameter to this solution?  My data has names that have both hyphens and apostrophes.