LEN( )The following example uses LEN( ) in conjunction with the RIGHT( ) and FIND( ) functions to display the characters that appear after the hyphen in a product code. RIGHT( ) extracts a substring of a specified length, starting from the last character. In this example, the length of the entire string returned by LEN( ) minus the length up to the hyphen is the number of characters to display:RIGHT([ProductCode], LEN([ProductCode]) - FIND("-" , [ProductCode]))If the product code is ModelA-Ford, the expression returns Ford.
|
|
Copyright Actuate Corporation 2012 |