Calc. (or script) To Replace UpperCase... crosspost

Discussion created by alc on Jun 22, 2013
Latest reply on Jun 23, 2013 by raybaudi

I need a calc which would substitute Each capital letter in a Word with a space then that character...



"ThisIsFourWords" would result in:

"This Is Four Words"


If neccessary, this could become a script... but either way, I'm stymied.


I keep considering analysing each letter against ASCII numbers, but even then can't come up with a solution that wouldn't be both complex and tedious.


Apologize to anyone else who also frequents the Filemaker Pro forums for crosspost... occured to me too late that this forum was more appropriate.


Thanks in advance.