Filter()

Filter()

Category: Text

Syntax: Filter ( textToFilter ; filterText )

Parameters: textToFilter ”any expression that resolves to a text string; filterText ”the characters to preserve in the specified text.

Description: Returns from textToFilter only those characters specified in filterText , in the order that they were originally entered in textToFilter . If filterText doesn't have any characters, an empty string is returned. The Filter() function is case sensitive.

Examples:

 Filter ( "ab123"; "abc") 

Returns ab .

 Filter ( PhoneNum ; "0123456789" ) 

Would strip any non-numeric characters from the PhoneNum field.

Comments: The Filter() function is frequently used to ensure that users have entered valid data into a field. The textToFilter parameter should contain any valid characters; the order of the characters within textToFilter isn't important.