MakePlural ( Text )

Covers plurals for common rules (some exclusions)

Average rating: 4.8 (12 votes) Log in to vote

Kieran Harvey
N/A
N/A

Sample input:

Branch
Site
Knife

Sample output:

Branches
Sites
Knives

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

Case ( 
               Right ( Text ; 2 ) = "ch" 
            or Right ( Text ; 2 ) = "sh" 
            or Right ( Text ; 1 ) = "s" 
            or Right ( Text ; 1 ) = "x" 
            or Right ( Text ; 1 ) = "z" 
               ; Text & "es" ;
               Right ( Text ; 2 ) = "fe"
               ; Left ( Text ; Length ( Text ) - 2 ) & "ves" ;
               Right ( Text ; 1 ) = "f" 
           and Right ( Text ; 2 ) ≠ "of" 
           and Right ( Text ; 2 ) ≠ "ef" 
           and Right ( Text ; 2 ) ≠ "ff"
               ; Left ( Text ; Length ( Text ) - 1 ) & "ves" ;
               Right ( Text ; 1 ) = "y" 
           and Length ( Filter ( Right ( Text ; 2 ) ; "aeiou" ) ) = 0
               ; Left ( Text ; Length ( Text ) - 1 ) & "ies" ;
               Text & "s" )

Covers most plural usage however does not work with

Tomato / Tomatoes
Oaf / Oafs

does work with
Loaf/Loaves
Kilo/Kilos
Site/Sites
Branch/Branches
Life/Lives

Comments

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

MakePlural ( Text )

Comments

Support this website.

Support this website.