Function: Strip


Strips the indicated characters from the string.




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"




© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support