Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

Title ( Text ; LeaveEmpty )

This is similar to FileMaker's built-in Proper() function, but much more practical for the real world. It was created with the proper formatting of song titles in mind, but can also be applied to book or movie titles, headlines and more.

  Average rating: 3.9 (54 votes) Log in to vote

Howard Schlossberg - Show more from this author FM Professional Solutions http://fmprosolutions.com

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

Let ( [ prefixList = "Mc"; alwaysLower = "a¶an¶and¶aka¶at¶by¶for¶ie¶in¶is¶it¶nor¶of¶on¶or¶the¶to¶vs¶vs.¶w/¶with"; alwaysUpper = "AC¶EMI¶RCA¶ABC¶INXS¶REM¶UB40¶UK¶USA¶OK¶USSR¶MTV¶NRG¶DJ¶MC¶H2O¶CD¶NY¶NYC¶ID¶EP¶TV"; prevText = LeaveEmpty; nextText = case(isempty(prevText) and Exact( Text, Upper(Text) ), lower(Text), Text); prevChar = Right( prevText; 1); prevChar_preSpace = Right( Trim(prevText); 1); prevChar_isUpper = Exact( prevChar_preSpace; Upper(prevChar_preSpace)); prevChar_isLower = Exact( prevChar_preSpace; Lower(prevChar_preSpace)); prevCaseType = Case( prevChar = " "; Case(prevChar_isUpper and prevChar_isLower; "symbol"; "space"); PatternCount("0123456789"; prevChar); "number"; prevChar = "'"; "apos"; prevChar_isUpper and prevChar_isLower; "symbol"; prevChar_isLower; "lower"; prevChar_isUpper; "upper"); currWord = RightWords(prevText; 1) & Left(nextText; Position(nextText & " "; " "; 1; 1)-1); currChar = Left(nextText; 1); /************************ PLEASE READ THE COMMENTS BELOW ***********************/ /******** THEY MAY HELP YOU WITH TWEAKS THAT BETTER FIT YOUR SITUATION *********/ currCase = Case ( // First character of the title is always uppercase IsEmpty ( prevText ); "upper"; // Always capitalize the first letter after any symbol // except an apostrophe (which is handled separately), even if that symbol // was followed by spaces (avoids an alwaysLower word from being lower if // it is really the beginning of a sentence) prevCaseType = "symbol"; "upper"; // Make it lowercase if it is in your alwaysLower value list WordCount( nextText ) > 1 and prevCaseType <> "symbol" and not IsEmpty( FilterValues( LeftWords ( nextText; 1); alwaysLower)); "lower"; // First letter after a space is always capitalized (unless it // was one of the previous arguments, like alwaysLower) prevCaseType = "space"; "upper"; // Make it uppercase if it is the first character after an item in your prefixList not IsEmpty ( FilterValues( RightWords(prevText; 1); prefixList ) ); "upper"; // The letter after an apostrophe is uppercase if there are more than a couple characters prevCaseType = "apos" and Length ( LeftWords(nextText; 1) ) > 2; "upper"; // Make it uppercase if it is in your alwaysUpper value list not IsEmpty( FilterValues( currWord; alwaysUpper)); "upper"; // The character after a number is always lowercase (to handle something like "19th") prevCaseType = "number"; "lower"; // You may or may not want this, as it helps but is imperfect. // It makes a "word" without vowels into all caps. // This will result in converting 'lcd' to 'LCD', which is probably desirable. // But it won't convert 'led' to 'LED' because 'Led' could also be a word. // It also tests for a period so that 'mrs' will convert to 'Mrs.' IsEmpty( Filter( currWord; "aeiouyAEIOUY")) and not PatternCount(currWord; ".") and prevCaseType <> "lower"; "upper"; // You may or may not want this, as it may or may not help your situation. // It makes it possible to enter 'LaFond' and keep it that way (as opposed // to 'Lafond'). The down side of this is that you may prefer to just // overwrite your users' potential inconsistencies. // Either way, it is imperfect for all situations. prevChar_isLower and Exact ( currChar; Upper ( currChar ) ); "upper"; "lower" ); /************** TWEAKING NOT RECOMMENDED BELOW THIS LINE ****************/ currChar = Case( currCase = "upper"; Upper(currChar); currCase = "lower"; Lower(currChar); "lower") ; nextText = Right ( nextText; Length ( nextText ) - 1 ) ] ; // end Let() parameters Case ( IsEmpty (Trim(nextText)); prevText & currChar; Title(nextText; prevText & currChar) ) ) // end Let() statement Click to copy

This was inspired by the SmarterProper() function (posted on this site by David Tremmel), but whereas that function was more befitting of people's names, I needed something that would also take into consideration that not all words in a song title or headline should be capitalized (ie: a, an, the, and, in, or, etc). And then I realized that some words should always be all upper-case (CD, USA, UK, and certain band names like REM or INXS, etc). So I rewrote David's function from the ground up to accommodate my needs.

This function allows you to easily add additional keywords that should always be lowercase or all-uppercase, depending on your particular needs and/or your users' bad habits.

The function also handles the proper formatting of some names that include some prefixes (ie: McDonald), though it is not properly suited for use with both names and titles (i.e. the prefix 'Mac', as in MacDonald, will also cause the synonym for computer to result in "MacHine"), so be careful here. And it capitalizes the letter after an apostrophe if there are more than just a couple letters after that apostrophe (to handle words like O'Malley without confusing it with Don't).

MORE EXAMPLES:
Title ( "old mcdonald had a farm"; "" ) returns "Old McDonald Had a Farm"
Title ( "o'shea"; "" ) returns "O'Shea"
Title ( "back in the ussr (the beatles)" ; "" ) returns "Back in the USSR (The Beatles)"
Title ( "the world. and more."; "" ) returns "The World. And More."
Title ( "m.i.a."; "" ) returns "M.I.A."
Title ( "19th nervous breakdown"; "" ) results in "19th Nervous Breakdown"
Title ( "more e-mail (don't we love it!)"; "" ) results in "More E-Mail (Don't We Love It!)"

Title ( "LaMond"; "" ) returns LaMond (rather than Lamond; it respects a capital letter that might have intentionally been entered if it comes after a lower-case letter )

 

Comments

		Ricky, Italy Jun 1, 2012
Hi Howard, thanks for sharing this great function! It works great but I noticed a few exceptions that you may consider to add within the code. This link might be of interest: http://aitech.ac.jp/~ckelly/midi/help/caps.html Check out "Phrasal Verbs"... it would be cool to add an exception list section for specific words ("Call On", "Carry On", "Get By", "Turn On" for example). Unfortunately I'm a newbie when it comes to CF/recursive calcs so I have no idea where to tweak it to make it work! Just an idea, thanks again for this! Very cool! Best, Ricky

		Dave Hobson, Bristol UK Aug 7, 2013
Works really well - very useful. Thanks for sharing.

		MW, Hong Kong Sep 13, 2014
Thank you for sharing this function, it works great except in the following situation: I pass an address to the function, if the address contains more than 7 numerals, then filemaker convert it into a number, e.g. Flat 111A, 2/F, Kin Wang Mansion Stage 2, 111-112 Sai Yee Street, Mongkok, Kowloon. The return is: 1.1122e+10

		MW, Hong Kong Sep 13, 2014
** Problem solved ** Thank you for sharing this function, it works great except in the following situation: I pass an address to the function, if the address contains more than 7 numerals, then filemaker convert it into a number, e.g. Flat 111A, 2/F, Kin Wang Mansion Stage 2, 111-112 Sai Yee Street, Mongkok, Kowloon. The return is: 1.1122e+10 Problem solved: I use the function as a calculation field and forget to change the output type from number to text, so filemaker attempt to convert the text into a number.

		Bryan Olson, Indiana University Oct 13, 2021
Thanks for sharing this. Does anyone have any tips for how I can modify this function to not capitalize words when they appear after a comma in a list? For example, I have a course title "Foundations of Biology: Diversity, Evolution, And Ecology" where the "evolution" and "and" are continuing to be capitalized when I want it to be lower case. Thanks!

		Carlo Vlekken, Vlekken Consult BV Jul 11, 2022
Copied this function but encountered syntax error in line: nextText = case(isempty(prevText) and Exact( Text, Upper(Text) ), lower(Text), Text); All "," should be ";" : nextText = case(isempty(prevText) and Exact( Text; Upper(Text) ); lower(Text); Text);

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 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: