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
Elim12
https://www.elim12.com.au/

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).

 

Comments

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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.