RTrim() returns the input string trimmed of any trailing spaces.
Syntax:
RTrim(text)
Return data type: string
| Example | Result |
|---|---|
| RTrim( ' abc' ) | Returns ' abc' |
| RTrim( 'abc ' ) | Returns 'abc' |
Set verbatim=1;
T1:
Load *, len(RtrimString) as RtrimStringLength;
Load *, rtrim(String) as RtrimString;
Load *, len(String) as StringLength;
Load * Inline [
String
' abc '
' def '];
Information noteThe "Set verbatim=1" statement is included in the example to ensure that the spaces are not automatically trimmed before the demonstration of the rtrim function. See Verbatim for more information.
Result
| String | StringLength | RtrimStringLength |
|---|---|---|
| def | 6 | 4 |
| abc | 10 | 6 |