How do I parse a string by capital letter?

[#1]

I have a single line of text column containing a CamelCase string.  How would I separate the words based on the Capital letter and put the results in another single line of text field?

Thanks!!

[powersj1 · Accepted solution]

You could use a workflow.  You would use a regular expression to separate them.  For the input text, use the field from the item properties tab.  Store the result in a single line of text and then update the item. One note, there is a space after ${word}.

Pattern:

(?<word>[A-Z][a-z]*)

Replacement text:

${word}

[pfudala]

If your need is in a Nintex Form, you could set a variable with a such formula :

trim(replace(Title,"([A-Z])"," $1"))

Then, connect this variable to the second field.

[#4]

Jeremiah,

Your answer was exactly what I needed!  I made one change which was to add a space after ${word}.  The space separated the words: CamelCaseParsedString became Camel Case Parsed String.

Thank you for the prompt reply!!!  You saved me a ton of manual effort.