TrimReturns ( text )

Trims leading and trailing paragraph returns.

Average rating: 3.9 (51 votes) Log in to vote

Kieren MacMillan
kierencom
http://www.kierencom.ca

Sample input:

TrimReturns ( "

this

is the
text

" )

Sample output:

this

is the
text

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

Let
(
    [
        $stripped = Substitute ( text ; “¶” ; “” );
        $firstChar = Left ( $stripped ; 1 );
        $lastChar = Right ( $stripped ; 1 );
        $fcPos = Position ( text ; $firstChar ; 0 ; 1 );
        $lcPos = Position ( text ; $lastChar ; 0 ; PatternCount ( text ; $lastChar ) )
    ];

    Middle ( text; $fcPos; $lcPos - $fcPos + 1 )
)

Trims leading and trailing paragraph returns, but could easily be modified to trim any other desired character(s), e.g., tab, space, period, etc.

Comments

		Steve, Lancaster Jul 12, 2014
Very nice and simply elegant. I tried for about an hour to do this....should've came here first! :) Thanks for sharing.

		JoÃ£o Coutinho Jun 19, 2019
Love the result :) Thanks!

		Robert D Trammel, Lucky Penny LLC Sep 8, 2023
Substitute( Trim( Substitute( ; "¶"; " " ) ); " "; "¶" ) works too! :)

		Robert D Trammel, Lucky Penny LLC Sep 8, 2023
Substitute( Trim( Substitute( YourListHere ; "¶"; " " ) ); " "; "¶" )

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

TrimReturns ( text )

Comments

Support this website.

Support this website.