I'd need a script to make each sentence lower case except for the first
letter. I can't see anything that does this. I could write something
that would do it, but I can;t believe its that hard. Is there an easy
solution that I am missing?

Thanks

Sure it's hard. Just look at your post:

hard. Is there an easy solution that i am missing?
<<

The I's have become i's. You would need a dictionary of proper words which
would be exceptions to the capitalization rule. You'd also need to check for
quotations, parenthesis, and other punctuation at the start of a sentence.
This becomes further complicated by the many languages that FileMaker Pro
supports. Even with all this effort, you would likely still have situations
where FileMaker inappropriately strips capital letters.

I would probably not include this feature in a database I built. But were I
forced to do so, an easy solution would be to substitute a return for each
<period><space> sequence, then step through the "values" (lines) in a field
using the Lower(), Proper() and Leftwords() functions, under script control.

Bill

"Luke Siemaszko" <no.spam.for.me (AT) please (DOT) com> wrote