Sign in to follow this  
Followers 0

Singular to plural word calculation

8 posts in this topic

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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?

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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"

)

)

Share this post


Link to post
Share on other sites

Posted

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!

Share this post


Link to post
Share on other sites

Posted

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?

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0