TextFilter ( InText )

Filter(), TrimAll(), and TextFormatRemove() in one function.

Be the first to rate this function Log in to vote

Richard DeShong - Show more from this author
Logic Tools
http://logictools.com

Sample input:

TextFilter( " Abcd<>Efg ¶" )

Sample output:

"AbcdEfg"

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

Let([
   InText = TextFormatRemove( InText ) ;
   InText= Filter( InText ; "abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ-'.@&()_:/1234567890" )
];
   TrimAll( InText ; 1 ; 0 )
)
// Removes formatting, forces to the specified list of characters, removes double/leading/trailing spaces.

I find that a large number of fields are expected to be one line of text (names, phones, emails, city, state, etc.). So I needed a function to clean the user's data entry. I did not want leading or ending spaces, no returns or tabs, and limit it to a specific list of characters (typical for the types of data entry fields). So this combines a number of text functions.

I sometimes use this in a field's autocalc: TextFilter( Self ).
Most often I use it in a script: After the user has specified data in a set of global fields and clicks to continue, I use TextFilter() on all of the global fields before I perform field-specific checks.

I also use this as the basis for creating specialized text filtering CF's, by changing the list of characters allowed.

Comments

		JoÃ£o Coutinho May 5, 2026
Nice one!

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

TextFilter ( InText )

Comments

Support this website.

Support this website.