@TrimAll ( text ; trimSpaces ; trimType )

Trims all 21 variants of the whitespace character.

Average rating: 5.0 (1 vote) Log in to vote

Alex Zueiv - Show more from this author
Tashkent
https://github.com/zueiv

Sample input:

Quote ( @TrimAll ( " ¶ Hello World! ¶ " ; 1 ; 1 ) )

Sample output:

"¶Hello World!¶"

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

// @TrimAll ( text ; trimSpaces ; trimType )
//
// A wapper for the standard FMP function TrimAll().
// Created 2018-08-23 by Alex Zueiv
//
// Replaces all types of whitespace characters with a regular
// space, and then trims them with the original function.
//
// Example: @TrimAll ( "  ¶  Hello    World!  ¶  " ; 1 ; 1 )
//
// See FMP Help of the original function for the parameters
// description.

TrimAll (

Substitute ( text ;

// the function Trim() handles these spaces, and TrimAll() does not:
[ Char (  160 ) ; " " ] ; // no-break space (U+00A0)
[ Char ( 8192 ) ; " " ] ; // en quad (U+2000)
[ Char ( 8193 ) ; " " ] ; // em quad
[ Char ( 8194 ) ; " " ] ; // en space
[ Char ( 8195 ) ; " " ] ; // em space
[ Char ( 8196 ) ; " " ] ; // three-per-em space
[ Char ( 8197 ) ; " " ] ; // four-per-em space
[ Char ( 8198 ) ; " " ] ; // six-per-em space
[ Char ( 8199 ) ; " " ] ; // figure space
[ Char ( 8200 ) ; " " ] ; // punctuation space
[ Char ( 8201 ) ; " " ] ; // thin space
[ Char ( 8202 ) ; " " ] ; // hair space
[ Char ( 8203 ) ; " " ] ; // zero width space (U+200B)
[ Char ( 8287 ) ; " " ] ; // medium mathematical space (U+205F)

// the both functions Trim() and TrimAll(;1;) handle this space:
// [ Char ( 12288 ) ; " " ] ; // ideographic space (U+3000)

// neither the functions Trim() nor TrimAll() handles these spaces:
[ Char ( 8204 ) ; " " ] ; // zero width non-joiner (U+200C)
[ Char ( 8205 ) ; " " ] ; // zero width joiner (U+200D)
[ Char ( 8239 ) ; " " ] ; // narrow no-break space (U+202F)
[ Char ( 8288 ) ; " " ] ; // word joiner (U+2060)
[ Char ( 65279 ) ; " " ]  // zero width non-breaking space (U+FEFF)

) ;

trimSpaces ; // set to 1 to replace full-width spaces (U+3000) with a regular one

trimType     // set to 1 to remove spaces around carriage returns

)

An improvement of the standard FMP function TrimAll(). Useful for cleaning texts received from a website, and to create multi-line key fields.

Comments

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

@TrimAll ( text ; trimSpaces ; trimType )

Comments

Support this website.

Support this website.