Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference SQUEEZE
Functions and Expressions Reference Guide
191
SQUEEZE
The SQUEEZE function removes consecutive duplicate occurrences of a specified
character or characters from a text item.
Syntax
SQUEEZE ( single-text-item , single-text-item )
Meaning
SQUEEZE ( text_to_squeeze , duplicate_characters_to_remove )
Returns
This function returns a single-text-item.
Returns a text item with all the consecutive duplicates of
duplicate_characters_to_remove removed from text_to_squeeze.
Examples
SQUEEZE ( "AB CDE F", " " ) returns AB CDE F.
SQUEEZE ( "Connolly", "n") returns Conolly
Uses
Use
SQUEEZE to remove duplicate characters from a text item.
Related Functions
LEAVEALPHA, LEAVEALPHANUM, LEAVENUM, LEAVEPRINT, SUBSTITUTE