Not applicable

How do I parse a string by capital letter?

Jump to solution

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!!

0 Kudos
Reply
3 Replies
powersj1
Apprentice

Re: How do I parse a string by capital letter?

Jump to 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}

0 Kudos
Reply
pfudala
Apprentice

Re: How do I parse a string by capital letter?

Jump to solution

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.

0 Kudos
Reply
Not applicable

Re: How do I parse a string by capital letter?

Jump to solution

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.

0 Kudos
Reply