sentencePunctuation ( testText )
Checks testText for terminating punctuation (.?!) and adds if needed.
Average rating: 4.8 (25 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This checks the passed text for appropriate terminating punctuation according to English language grammar rules. It will catch:
* anything ending in alphanumeric characters and add a period;
* anything ending in a closing bracket, brace, parenthesis or quote mark (or combination of any two of these) without terminating punctuation and add a period;
* anything ending in non-terminating punctuation and add a period; and
* anything ending in unacceptable punctuation (comma, semicolon and colon) and replace that punctuation mark with a period.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.