Brian Dunning's FileMaker Custom Functions

ProperAllWords ( text )

Use FileMaker Proper() function to proper all words in a sentence

  Average rating: 1.0 (1 vote) Log in to vote

Kevin Hwang   Kevin Hwang - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
today is a good day to drink cocktail
  Sample output:
Today Is A Good Day To Drink Cocktail

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This custom function converts all words in a sentence with first letter capital for all words. It uses FileMaker's native Proper() function. I think people can write this up easily but no one has post it up here. If someone has, pardon me.

Caution: this might not serve the purpose well for state abbreviation (all caps).



Henk Brendel   Henk Brendel, Arnhem NL
Dec 15, 2017
Why not use the proper 'Proper ()' function?

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 15 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: