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.

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).

Comments

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.