This expression only looks for spaces to separate one "word" from another.
Set Field [YourTable::YourTextField; Let ( [Fld=YourTable::YourTextField; Break = Position ( Fld ; " " ; 80 ; 1 )] ; Left ( Fld ; Break ) & "¶" & Right ( Fld; Length (Fld) - Break ) )
The expression works for the first 80, not after. In the example I am using has 245 characters.
That's a detail not clear in your original post.
You can loop the script, substituting a variable for the "80" parameter in the Position function:
Set Variable [$NextBreak; value: 0]
Set Variable [$NextBreak; Position (YourTable::YourTextField; " " ; NextBreak$ + 80 ; 1]
Exit Loop if [$NextBreak = 0]
Set Field [YourTable::YourTextField; Let ( Fld=YourTable::YourTextField; $NextBreak) ; Left ( Fld ; $NextBreak ) & "¶" & Right ( Fld; Length (Fld) - $NextBreak ) )
You may have to tweak that a bit, but I think that'll do what you want.
Sorry for not being more clear. The text block will be of varing size, with out any user instered Paragraphs, just one long Paragraph.
I was entering your script, but I keep getting errors on the last Set Field command, just before the Left command.
I am now seeing just how much my FileMaker skills have atrophied! :)
Never mind, I made some changes, and now it works just as I want it to!
Thanks again for all the great help!