Substitute ( Proper ( Title ) ; ["Wwii" ; "WWII"] ; ["Wwi" ; "WWI" ] )
Might work, but using the brackets to list all the possible exceptions could be a major chore and you have to pay attention to cases where this might not work. The above example, won't work if I subsitute for "wwi" before "Wwii" or I'll get WWIi for example...
A custom function that returns the Proper of every word that does not contain a capitalized letter in the 2nd or subsequent letter of the word would not need such a list of exceptions. I'd guess that the solution on the briandunning site might well be such a custom function. (Adding a custom function to a fileMaker file requires using FileMaker Pro Advanced.)
Thanks for the pointers Phil
Substitute, that's the one I was looking for. Until I have time to learn how to write a custom function of my own I guess this will have to suffice... although maybe I should take the time to make my own custom function because than I could have one list (in the custom function) and use it throught my database.
If you search the web, you may find that there is already a custom function that can do this--which you can then import into your file. Such an imported custom function would be something you could also "use throughout" your file and would save you the trouble and time of creating your own.
Could you post a link to one? I can seem to find one based on any of the search keywords I can think of.
Don't know one either--which is why I said there may be one out there...
Searching the Brian Dunning site using "Capital" as my search term produced two possible functions.
This one seemed like the best fit: