Navigator User Guide

10.4.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0 HotFix 1
- 10.4.0

Back Next

RTrim

Trims a specified character from the right side of a field.

The field to be trimmed must be a similar data type as the target field For example, you cannot use the RTrim function to copy a field with a character data type to a target field with a numeric data type.

Syntax:

RTrim(field,'character')

The following table describes the parameters:

Parameter	Description	Datatype
`result`	Returns the contents of the field trimmed of the specified character from the right side.	CHAR
`field`	The field to be trimmed.	CHAR
`character`	Optional. The character to trim from the right side of the field. If a character is not specified, space is the default. Enclose the character value in single quotes.	-