TrimAll_CR ( Text )

All redundant returns: leading, trailing and the extra returns between values will be removed

Average rating: 4.6 (32 votes) Log in to vote

Menno van Beek - Show more from this author
Van Beek Zakelijke Software
https://www.vbzs.nl

Sample input:

TrimAll_CR ( "

All redundant returns:

leading, trailing and the extra returns

between values will be removed

" )

Sample output:

All redundant returns:
leading, trailing and the extra returns
between values will be removed

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

/*
###########################################
# TrimAll_CR function
# Author:
# Menno van Beek - Van Beek Zakelijke Software - Woerden, the Netherlands
# Format:   
# TrimAll_CR ( Text )
# Parameters:
# Text - Textstring with carriage-returns leading, trailing and/or 
# between values
# Data type returned:
# text   
# Description:   
# All redundant returns: leading, trailing and the extra returns 
# between values will be removed
# July 31, 2012
###########################################
*/

Case (
    PatternCount ( Text ; "¶¶" ) ; 
        TrimAll_CR ( Substitute ( Text ; [ "¶¶" ; ¶ ] ) ) ;

    Left ( Text ; 1 ) = ¶ ; 
        TrimAll_CR ( Right ( Text ; Length ( Text ) - 1 ) ) ;

    Right ( Text ; 1 ) = ¶ ; 
        TrimAll_CR ( Left ( Text ; Length ( Text ) - 1 ) ) ;

        Text 
    )

All redundant returns: leading, trailing and the extra returns between values will be removed.

The function is recursive, but very fast since it only has between 1 and 3 iterations.

Comments

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

TrimAll_CR ( Text )

Comments

Support this website.

Support this website.