LEFT( )Extracts a substring from a string, starting from the left-most, or first, character.The following example displays the first letter of each name in the CustomerName field:The following example uses the LEFT( ) and FIND( ) functions to display the characters that precede the hyphen in a product code:LEFT([ProductCode], FIND("-", [ProductCode]))If the product code is ModelA-1234, the expression returns the following string:
|
|
Copyright Actuate Corporation 2012 |