Help with substring function
Posted on 2011-10-21
Here is my problem.
I have a string, let's say it is "Herman Newsome" and I want to convert it to first_name and a last_name strings.
I have already done the conversions so that the only upper case letters in the names are the first letter, so what I need to do now is capture the two values into different strings.
I can't just check for the first white space, because there might be a middle name in the string like "Herman von Newsome" so what I need to do is check for the next capital letter. I was thinking maybe checking unicode values, but I'm not sure if that is the best bet.