Right
Use this function to return a specified number of right most characters.
Syntax
|
Parameter |
Description |
|
Enter a valid string. The default is the value of the current field text. |
|
|
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. |