Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference LEAVEALPHA
Functions and Expressions Reference Guide
141
LEAVEALPHA
The LEAVEALPHA function removes all non-alphabetic characters from a specified
text item.
Syntax
LEAVEALPHA (single-text-expression)
Meaning
LEAVEALPHA (text_to_change)
Returns
This function returns a single-text-item.
Returns a string containing only the alphabetic characters (for example, A-Z
and a-z) in text_to_change.
Examples
LEAVEALPHA ("A-b-C-1$3") returns AbC
Uses
Use
LEAVEALPHA to remove non-alphabetic characters such as symbols or
numbers from a text item.
Related Functions
ISALPHA, ISLOWER, ISNUMBER, ISUPPER, LEAVEALPHANUM, LEAVENUM,
LEAVEPRINT