Singular to plural word calculation

[dmontano]

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.

[David Jondreau]

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?

[David Jondreau]

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

[comment]

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.

[comment]

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"

)

)

[dmontano]

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!

[dmontano]

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?

[David Jondreau]

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