ProperAllWords ( text )

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

Average rating: 1.0 (2 votes) Log in to vote

Kevin Hwang - Show more from this author
Elim12
https://www.elim12.com.au/

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)

/*
Sometimes need to Proper all words like making an address looks right. But caution this might not serve the purpose well for state abbreviation (all caps). 
*/

Let ( 
[wcount = WordCount ( text )];
If(
wcount  ≥  1 ; Proper(LeftWords ( text ; 1 )) & " " & ProperAllWords(RightWords ( text ; WordCount ( text ) - 1 ));
""
)
)

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, Arnhem NL Dec 15, 2017
Why not use the proper 'Proper ()' function?

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

ProperAllWords ( text )

Comments

Support this website.

Support this website.