Calculation field problem

[Robert Collins]

I have a text field that a user can enter a message. I know how to get a field to count how many characters in that text field using the Length function but what need is a field to show how many lots of 160 characters there are in the text field. For example if the message length is 140 then the result is 1 and if the message length is 267 the result is rounded to 2 ect. I could use the Case funtion but with so many possible results this is not ideal.

Any help would be appreciated

[comment]

How about:

Round ( Length ( Textfield ) /160 ; 0 )

[Robert Collins]

thanks I did try that but it didn't quite give me what I wanted . I might not have explained myself clearly

this is what I would like

up to 160 =1

up to 320 =2

ect

[comment]

Try:

Div ( Length ( Textfield ) - 1 ; 160 ) + 1

[Robert Collins]

Excellent! thanks very much