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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: