I have a customer name that I use the "capitalize" function of the String Manipulation Node to make the first letter capitallzed followed by lower case letters. That works fine. But I want to Also capitalize the first letter after the dash character in the event of a hyphenated name. For example "Smith-johnson" should actually read "Smith-Johnson".
My work around has been to split the column on the hyphen using Split Cell, capitalize each word, then rejoin. But now I'm trying to create a template metanode. And the problem is I don't know how many cells might be created by the Split Cell. I can continue to do a lot of work around like assume some maximum number, rejoin them, and then filter the columns with forced inclusion. Im bettering someone in the forum has a better solution.
Should I consider doing a column name loop? Or some other loop that looks at the characters of a string one byte at a time?