Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Title Casing a Hyphenated String

Highlighted
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!

Highlighted
7 - Meteor

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

TitleCase.PNG

Highlighted
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

Highlighted
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