Given the following two sample words:

1. Party

2. Animal

What 1 calculation can be used to make these words plural like this:

1. Parties

2. Animal

I have tried for 30 minutes and I give up.

Case( word = "Party"; "Parties"; word = "Animal"; "Animals")

But I suppose your looking for something that will work with any noun.

I doubt that's possible.

What's the bigger picture? Would the Spelling scripting functions help?

Setting up rules to pluralize each of the following words would be impossible.

dog

knife

data

child

sheep

mouse

news

crisis

potato

memo

elf

dwarf

attorney-general

What 1 calculation can be used to make these words plural

I guess a calculation that would follow these rules:

http://en.wikipedia.org/wiki/English_plural

Al least the regular plurals shouldn't be too hard to implement.

Here's something that could serve as a starting point:

Let ( [

len = Length ( word ) ; 

lastChar = Right ( word ; 1 )

] ;

Case ( 



not IsEmpty ( Filter ( lastChar ; "sxz" ) )

or

not IsEmpty ( FilterValues ( Right ( word ; 2 ) ; "sh¶ch" ) ) ;

word & "es" ;



lastChar = "y" and IsEmpty ( Filter ( Middle ( word ; len - 1 ; 1 ) ;  "aeiou" ) ) ;

Left ( word ; len - 1 ) & "ies" ;



word & "s"

)

)

Hi DJ,

Bigger picture... not very broad. Layouts in solution are based on table (singular name), but layout should be "presented" in plural. I agree it would be impractical for all nouns, but my scope is quite small.

I think your approach of Case would be just fine. I hacked this up before checking responses and it seems to work for now:

If (

Right ( Get ( LayoutName ) ; 1 ) = "y";

Proper (

Substitute (

Get ( LayoutName ); ["_" ; " "] ; [ "y"; "ie"] )

)

&

"s"

;

Proper (

Substitute (

Get ( LayoutName ); "_" ; " " )

)

&

"s"

)

Hi Comment,

Thanks for pitching in. I am going to plug what you've created in to see if I can understand it.

Than you both - much appreciated!

Hi Comment,

I plugged in the formula and I get a "function not found" and then it highlights the first "not IsEmpty" portion of the formula.

Any ideas what I am missing?

Why not just have the table and layout names match up? Make the table names plural.