Function: Strip

Description

Strips the indicated characters from the string.

Syntax

Strip(string,stripchars)

Arguments

string is the string you wish to strip characters from and stripchars is the list of characters to strip out. Note: stripchars is case-sensitive.

Return value

This function returns a string without the characters specified in stripchars.

Calculated field example

To strip dashes from a Social Security number, use the following calculated field expression: Strip("123-45-6789","-")

Filter/Find example

Records with a normalized telephone number of 9784412200 could be found using Strip(TelNo,"- ()")="9784412200"