Data Integration
- Data Integration
- All Products
sff:rtrim(str, trim_set)
Argument
| Required/
Optional
| Description
|
---|---|---|
string
| Required
| Any string value. Passes the values that you want to trim. You can enter any valid transformation expression. Use operators to perform comparisons or concatenate strings before removing blank characters from the end of a string.
You must enclose the string value within single or double quotation marks.
To pass a NULL value, you must specify an empty sequence in the following format:
()
|
trim_set
| Optional
| Any string value. Passes the characters that you want to remove from the end of the string. You can also enter a text literal.
You must enclose the string value within single or double quotation marks.
To pass a NULL value, you must specify an empty sequence in the following format:
()
The rtrim function is case sensitive. For example, if you want to remove the 'o' character from the string 'Alfredo', you would enter 'o', not 'O'.
|
sff:rtrim( LAST_NAME, 're')
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
sff:trim( sff:rtrim( NAMES ), 't' )