Return to String Function Index
String Function Syntax and Examples
RTRIM( )The RTRIM() function removes all consecutive instances of the specified character from the right side of a string. If more than one character is specified for the char argument, only the first is used.
Syntax:
RTRIM(string,char)
where:
char is the character to be removed.
Example:input: samplestringXXX
IMPORT @sample.dat
{RECORD
{
field1 *\r\n
}
schema1.table1
{
col1 RTRIM(field1,'X')
}}
Results:
schema1.table1.col1 samplestring
Return to String Function Index