How to remove characters 1

[Goalie3533]

I need to create a formula that determines how many characters are in a string. If the string length is greater than 17, I need to remove all characters after the 17th and add to the string: "..."

So "Hello. How are you doing today?" would become "Hello. How are y..."

If the string length is less than 17, leave it alone.

How would I create this in crystal? Thanks in advance.

-Goalie35

 

[fredp1]

Go to the field explorer, right click on formulae field, click new, name it say Shorter Text

If len({table.field})>17 then
left({table.field),17)+'...'
else
{table.field}

(use your field name for {table.field}

Cheers
Fred

 

[Goalie3533]

Thanks for the help fred.