Sentence Case

[pes]

Does anyone know a quick and easy way to convert text to sentence case? Is there some plug-in or simple script that will allow me to do this in Filemaker?

[Chuck]

There may be a plug-in that can do this more easily, but you can do it all within FileMaker.

Does the field have only one sentence? If so, then a script with the following step should work.

Set Field [ Text_Field, Upper( Left( Text_Field, 1 ) ) & Right( Text_Field, Length( Text_Field ) - 1 ) ]

If, however, there could be multiple sentenses, then it's going to get more complicated. You would have to loop through every character in the field to see if it comes two spaces after a period (assuming that that is a way we can tell when a new sentence begins). If you're on a Mac, this would probably be easier with AppleScript, as it has some more powerful text editing abilities. Let me know if this is the case, and I'll try to come up with something.

Chuck