STRIPEX

Description

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

Note: Use STRIPEX for Unicode data. For non-Unicode data, use the STRIP function.

Syntax

STRIPEX ( SourceField, "Type" )

Parameter	Description
SourceField	The string to be evaluated.
Type	Thetype 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

Thetype 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, postal codes and social security numbers. Use in conjunction with FORMAT or TEXT.

Examples

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

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