Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference TRIMRIGHT
Functions and Expressions Reference Guide
213
TRIMRIGHT
The TRIMRIGHT function removes trailing characters from a text item.
Syntax
TRIMRIGHT ( single-text-expression [ , single-text-expression
] )
Meaning
TRIMRIGHT ( item_to_trim [ , text_to_trim ] )
Returns
This function returns a single-text-item.
Removes trailing characters that match text_to_trim from item_to_trim and
returns the result as a single-text-item. If text_to_trim is not specified, trailing
spaces are removed from item_to_trim.
Example
TRIMRIGHT ( "abc " ) returns abc
TRIMRIGHT ( "Cat in the Hat!?!?!?" , "!?" ) returns Cat in the
Hat
TRIMRIGHT ( LastName Column:Row ) returns the content of LastName
Column after removing all trailing spaces.
Uses
Use
TRIMRIGHT to remove spaces or some other text string at the end of text.
Related Functions
FILLLEFT, FILLRIGHT, LEAVEALPHA, LEAVEALPHANUM, LEAVENUM,
LEAVEPRINT, SQUEEZE, SUBSTITUTE, TRIMLEFT