M
MS
Hello,
I'm trying to format a field using the proper case (Like In This Sentence).
I tried to play with the substring-before and substring-after functions but
they return blank if I'm trying to update the current field from it's own
value. It seems to be working if I'm updating, let's say, field2 using
field1's value.
Either way, I can't really think of a formula that works recursively,
regardless of how many words the sentence has.
Any help would be greatly appreciated.
Thank you in advance,
Mircea
I'm trying to format a field using the proper case (Like In This Sentence).
I tried to play with the substring-before and substring-after functions but
they return blank if I'm trying to update the current field from it's own
value. It seems to be working if I'm updating, let's say, field2 using
field1's value.
Either way, I can't really think of a formula that works recursively,
regardless of how many words the sentence has.
Any help would be greatly appreciated.
Thank you in advance,
Mircea