1 Reply Latest reply: Sep 18, 2014 11:03 AM by Olly Bond RSS

    Breaking a long text strings into fixed length

    PYelton _

      Hi All,

       

      This is my first time posting since the change to this new "forum".  Please forgive any mistakes.

       

      I am using Monarch 10.5.  Is there a function/technique for breaking a long text string into two text strings of a fixed length?  For example, I have a character field that has a length of 100 characters.  This field contains a sentence.  I would like to get this field into two fields of 60 characters each by breaking at a space as close as possible to the end of the first 60 characters.  In other words, perform a word wrap based on the maximum number of characters provided.

       

      Thanks for any help!

       

      Paul