Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Title Casing a Hyphenated String

madslawton3
6 - Meteoroid

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!

3 REPLIES 3
rbyrne
7 - Meteor

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

TitleCase.PNG

vijaykumarmv
6 - Meteoroid

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

TitleCase.PNG

 

Thanks,

Vijay

amazz24
7 - Meteor

@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.

Labels