Skip to main content
  • EN

Hi all

I have an attribute whose values are all written in PascalCase, for example "PleaseHelpMeOutHere".

I'd like to add a space at any capital letter, making a more readable string "Please Help Me Out Here". I don't need to preserve the original attribute.

To make it a little more complicated, some attributes have more than one capital letter, which I'd like to preserve (except for the last capital, which denotes a new word). For example "SOSHelpMeOutHere" becomes "SOS Help Me Out Here"

My guess would be that using a StringReplacer with Regex would work, but Regex is a foreign language to me. I could always use a PythonCaller, but I'd prefer to avoid that if possible.

Thanks

Hi @ld, assuming that only English alphabet characters would appear, the StringReplacer with this setting might help you.

  • Mode: Replace Regular Expression
  • Case Sensitive: Yes
  • Text To Replace: (?<=.)([A-Z][a-z])
  • Replacement Text: <space>\\1

Replace the '<space>' with an actual space character.

Reply


Community Stats

31,821
Posts
120,861
Replies
39,451
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.