community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Title Casing a Hyphenated String

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!

Meteor

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

TitleCase.PNG

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

Labels