Truncate text box characters

[Jono]

Is there a way to truncate the data in a text box?

I have a text box (1) that will have varying lengths of text. I set a rule
that if this box (1) is not empty to set the value of another text box (2) to
the same as text box (1). I then set the "Limit text box to x characters" on
text box (2) to 8 characters.

It doesn't limit the characters to 8...it gives me exactly what is in text
box (1).

Is there a better way to do this?

 

[S.Y.M. Wong-A-Ton]

If you are using a rule to set the value of text box 2, use the substring()
function with a length of 8. For example, set the value of text box 2 to:

substring(field1, 1, 8)

where field1 is text box 1.