Hello!

Anyone know how to construct a calculation

to convert long title/text to a short easily displayed short title?

example:

The Wonderful Walruses Went Home

~ to ~

The Wonderful Walrus...

I started this, but don't know how to finish it off, or if it is right to begin with:

Case(

Length (title) > 10; "Too Long"

)

obviously "Too Long" is NOT the result I want.

Any help???

:)

How about

LeftWords(Title; 3) & "..."

EDIT: or more specifically to your example

Left(Title; 10) & "..."

doughemi! this works perfectly for what I needed, thank you for your help. :)

DougHemi or any kind persons

This current calculation appends the "..." regardless if the title was reduced or not. I'm looking for the "..." be included only if title has been cut to size.

Any suggestions?

wooot'woot!

LeftWords ( Title ; 3 ) & If ( WordCount ( Title ) > 3 ; "..." )

or

Case(

Length(Title) > 10; Left(Title;10) & "...";

Title

)

Great, THANKS a heap!