Brian Dunning's FileMaker Custom Functions

sentencePunctuation ( testText )

Checks testText for terminating punctuation (.?!) and adds if needed.

  Average rating: 4.8 (25 votes) Log in to vote

Matthew Miller   Matthew Miller

Share on Facebook Share on Twitter

  Sample input:
sentencePunctuation ( "This is an incorrectly terminated sentence" )
  Sample output:
This is an incorrectly terminated sentence.

  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.



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.