LEN( ) Counts the number of characters in a string. Syntax LEN(str) Argument str The string expression to evaluate. Returns The number of characters in the specified string. Example The following example returns the length of each value in the ProductCode data field: LEN([ProductCode]) 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: A-Ford
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy