You are here: Function Reference > Alphabetical Listing > R > Right

Right

Use this function to return a specified number of right most characters.

Syntax

Right (String, Integer)

Parameter

Description

String

Enter a valid string. The default is the value of the current field text.

Integer

Enter the desired length for the output. The default is the length of the String parameter.

If the length you specify in the integer parameter is longer than the string, the system pads the result with spaces to reach the requested length. The input string is first trimmed of leading and trailing spaces before the output is determined.

Example

Here are some examples:

(Assume the current field contains the text Your Name.)

Function

Result

Explanation

Right ( )

"Your Name"

Defaults to the current field; No length was specified; therefore the field remains the same.

Right (" est text", 9)

"test text"

Takes the nine right most characters from the specified field and returns the result.

Right ("Complete Street Address", 14)

"Street Address"

Takes the 14 right most characters from the specified field and returns the result.

See also

© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.