NumberVar BreakPoint ;
//find the last space before 50 characters
If Length({AddressField}) > 50 then
BreakPoint := InStrRev(50, {AddressField}, " "
Else
BreakPoint := 0 ;
// print out the first field
If BreakPoint > 0 then
{AddressField}[1 to BreakPoint]
Else
{AddressField}
In another formula, print out the second half
NumberVar BreakPoint ;
If BreakPoint > 0 then
{AddressField}[(BreakPoint + 1) to Length({AddressField})]
Else
""
Malcolm
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.