cfWordWrap ( text ; numberOfCharacters )

Recursive Word Wrap function

Be the first to rate this function Log in to vote

Robert D Trammel - Show more from this author
https://www.linkedin.com/in/robertdtrammel/

Sample input:

cfWordWrap( "Hello my name is Jerry"; 6 )

Sample output:

Hello my
name is
Jerry

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*This is someone else's function from the community, but I couldn't find it to reference it. This function is really great because it breaks on the word instead of the character. */

Let ([
    CleanText = Trim ( Substitute ( Text ; ¶ ; " "  ) ) ; 
    TruncatedText = Left ( CleanText ; numberOfCharacters + 1 ) ;
    CountOfSpaces = PatternCount ( TruncatedText ; " " ) ; 
    PositionOfLastSpace = Position ( TruncatedText ; " " ; 1 ; CountOfSpaces ) ; 
    ThisLine = Trim ( Left ( TruncatedText ; PositionOfLastSpace ) ) ; 
    UnprocessedText = Right ( CleanText ; Length ( CleanText ) - PositionOfLastSpace ) ; 
    Result = If ( Length ( CleanText ) ≤ numberOfCharacters ; 
            CleanText
        ; 
            ThisLine & " ¶" & cfWordWrap ( UnprocessedText ; numberOfCharacters )
        )
]; 
    Result
)

Word wrap function that inserts line breaks by the word based on the characters given instead of the word.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

cfWordWrap ( text ; numberOfCharacters )

Comments

Support this website.

Support this website.