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( [PRODUCTNAME], LEN([PRODUCTNAME] ) - (FIND("-" ,[PRODUCTNAME] )))If the product code is ModelA-Ford, RIGHT( ) returns the following string:
|
|
Copyright Actuate Corporation 2012 |