right PowerHome formula function
Description
Obtains a specified number of characters from the end of a string.
Syntax
right ( string, n )
| Argument |
Description |
|
string
|
The string from which you want characters returned
|
|
n
|
A long whose value is the number of characters you want returned from the right end of string
|
Return value
String. Returns the rightmost n characters in string if it succeeds and the empty string ("") if an error occurs.
If n is greater than or equal to the length of the string, Right returns the entire string. It does not add spaces to make the return value's length equal to n.
Examples
The following examples demonstrate typical syntax/ usage for this function.
• right("[LOCAL1]",10) --> get the last 10 characters from the string.
• if( right( "[LOCAL1]", 12 ) = "HTTP/1.1 404", "ERROR", "Nextline") --> Return "ERROR" if the last 12 characters indicate an HTTP error.