STRIP

Description

Returns only the requested type of characters from a string: alpha, numeric, punctuation, whitespace, other/unknown.

Note: STRIP converts the SourceField parameter to ANSI encoding and therefore does not correctly handle Unicode data. For Unicode data, use STRIPEX.

Syntax

STRIP ( SourceField, "Type" )

Parameter	Description
SourceField	The string to be evaluated.
Type	The type of character to return, one of: A — Alpha N — Numeric P — Punctuation W — Whitespace O — Other or unknown

Parameter

Description

SourceField

The string to be evaluated.

Type

The type of character to return, one of:

A — Alpha
N — Numeric
P — Punctuation
W — Whitespace
O — Other or unknown

Remarks

This function is useful for reformatting data such as phone numbers, zip or postal codes and social security numbers. Use in conjunction with FORMAT or TEXT.

Examples

STRIP("(603) 555-1234","N") returns "6035551234"

STRIP("abc123.456def", "AP") returns "abc.def"