Im looking for a more advanced version of:
I would like the calculation to make the first word proper, and then each subsequent word that follows a full-stop .
so for example the calculation would change:
the cat sat on the mat. the cow jumped over the moon.
The cat sat on the mat. The cow jumped over the moon.
It is important that the textformatremove is still incorporated into the script to ensure that any copy and paste text is put into the correct format.
As always any help would be much appreciated.
I suggest searching one of the sites that maintain a library of custom functions for a custom function to do this. Custom functions require FileMaker Advanced in order to add them to your file.
And please note that typed in capitalization is not removed by the text format remove function.