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!
Solved! Go to 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
@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.