Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference LEAVENUM
Functions and Expressions Reference Guide
143
LEAVENUM
The LEAVENUM function removes all non-numeric characters from a text item.
Syntax
LEAVENUM (single-text-expression)
Meaning
LEAVENUM (text_to_change)
Returns
This function returns a single-text-item.
Returns a string containing only the numeric characters (for example, 0-9) in
text_to_change.
Example
LEAVENUM ("A-b-C-1$3") returns 13
Uses
Use
LEAVENUM when you want to remove all non-numeric characters such as
alphabetic characters and symbols from a text string.
Related Functions
ISALPHA, ISLOWER, ISNUMBER, ISUPPER, LEAVEALPHA,
LEAVEALPHANUM, LEAVEPRINT