left PowerHome formula function
Description
Obtains a specified number of characters from the beginning (left side) of a string.
Syntax
left ( string, n )
| Argument | Description |
| string |
String containing the characters you want to search. |
| n |
Integer. A number specifying the number of characters you want to return. |
Return value
String. Returns the leftmost 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, Left 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.
• left("[LOCAL1]",10) --> get the first 10 characters from the string.
• if( left( "[LOCAL1]", 12 ) = "HTTP/1.1 404", "ERROR", "Nextline")