Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference LEAVEPRINT
Functions and Expressions Reference Guide
144
LEAVEPRINT
The LEAVEPRINT function removes all non-printable characters from a text item.
Syntax
LEAVEPRINT (single-text-expression)
Meaning
LEAVEPRINT (text_to_change)
Returns
This function returns a single-text-item.
Returns a string containing only printable characters in text_to_change.
Example
LEAVEPRINT ("A-b<SP>C-1$3<CR><LF>") returns A-b C-1$3
Uses
Use
LEAVEPRINT to remove all non-printable characters from a text string.
Related Functions
ISALPHA, ISLOWER, ISNUMBER, ISUPPER, LEAVEALPHA,
LEAVEALPHANUM, LEAVENUM