TrimInvalidTrailingChars ( invalidChars ; textToTrim )

Trim given characters if they occur at the tail of a string

Average rating: 4.5 (2 votes) Log in to vote

Benjamin Storrier - Show more from this author
Studio Mondo
http://www.studiomondo.com.au

Sample input:

TrimInvalidTrailingChars ( "-" , "testString--" )

Sample output:

testString

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

// Ensures any character given never appears as the last character in a string. 
// Nice. Recursive. Functional.

Let ( [
  ~lastCharOfCurrentStringIsInvalid = Length ( Filter ( Right ( textToTrim ; 1 ) ; invalidChars ) ) ;
  ~truncatedString = Left ( textToTrim ; Length ( textToTrim ) -1 ) ;
  ~lastCharOfTruncatedStringIsInvalid = Length ( Filter ( Right ( ~truncatedString ; 1 ) ; invalidChars ) ) 
  ] ;
  Case (
    ~lastCharOfCurrentStringIsInvalid = 0 ;
      textToTrim ;
    ~lastCharOfTruncatedStringIsInvalid ≠ 0 ;
      TrimInvalidTrailingChars(invalidChars; ~truncatedString) ;
    ~truncatedString
  )
)

Ensure specific characters never appear as the last character in a string by trimming them off using this handy function.

- Handles multiple illegal characters given to the function as a string.
- Recursively trims illegal trailing characters until a legal one is found.

Comments

		19752, fmc Apr 8, 2018
It can be non-recursive. Let ( [ ~lastCharIsValid = Right ( Substitute ( textToTrim ; invalidChars ; "" ) ; 1 ) ; ~lastPositionOfValidChar = Position ( textToTrim ; ~lastCharIsValid ; Length ( textToTrim ) ; -1 ) ] ; Case ( ~lastCharIsValid = "" ; "" ; Left ( textToTrim ; ~lastPositionOfValidChar ) ) )

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

TrimInvalidTrailingChars ( invalidChars ; textToTrim )

Comments

Support this website.

Support this website.