Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference LEAVEALPHANUM
Functions and Expressions Reference Guide
142
LEAVEALPHANUM
The LEAVEALPHANUM function removes all non-alphanumeric characters from a
specified text item.
Syntax
LEAVEALPHANUM (single-text-expression)
Meaning
LEAVEALPHANUM (text_to_change)
Returns
This function returns a single-text-item.
Returns a string containing only the alphanumeric characters (e.g., A-Z, a-z
and 0-9) in text_to_change.
Example
LEAVEALPHANUM ("A-b-C-1$3") returns AbC13
Uses
Use
LEAVEALPHANUM to remove non-alphanumeric characters such as symbols
from a text item.
Related Functions
ISALPHA, ISLOWER, ISNUMBER, ISUPPER, LEAVEALPHA, LEAVENUM,
LEAVEPRINT