Description
Len returns a Number indicating the length of the given string.
Action
Len returns a Number indicating the length of the given string.
Text strings must be enclosed in quotation marks. Any blank spaces are included as part of the character count.
Typical use
Use this function any time you have a manipulation, comparison, or calculation that is dependent on the length of a text string.
Examples
Len("Account")
Returns 7.
Len("Text String")
Returns 11. The blank space between "Text" and "String" is counted as a character.
Len(" Center ")
Returns 10. There are 2 spaces on either side of the word "Center".
Len(ToText({orders.ORDER AMOUNT}))
Returns 9, where {orders.ORDER AMOUNT} is 14233.08, and ToText ({orders.ORDER AMOUNT}) returns the String "14,233.08". Here, the comma and period have been specified in the Number format for the formula field as the thousands and decimal separators respectively.
Len(ToText({orders.ORDER AMOUNT}, 2, "", "."))
Returns 8 where {orders.ORDER AMOUNT} = 14233.08, and ToText ({orders.ORDER AMOUNT}, 2, "", ".") returns the String "14233.08". Here, the null character and period have been specified in the Number format for the formula field as the thousands and decimal separators respectively.
Len({customer.CUSTOMER NAME})
The length of the text string stored as a value in {customer.CUSTOMER NAME}.