Hi all.

Is there a way to tell the RIGHT function to extract all the characters in a
string preceding a second capital letter?

We have a data set that contains concatenated Firstnames and Lastnames. For
example:

JoeSmith
JonathanJones
JamieJensen

We need to break the first names out into a separate column... I know how to
use RIGHT to grab a fixed number of characters or even characters preceding
a space... But in this case, I need to tell it to grab everything preceding
a CAPITAL letter.

Any ideas?

Much appreciated!!

Mouse