Len Function
Len (text as String) as Numeric
| Category: | Text |
| Description: | Returns the number of characters in a text string |
| Supported Context: | FormulaField And BusinessRules |
| Parameters: | |
| text as String | Represents a text string or reference to a field that returns a value of type text |
| Returned value as Numeric | Returns a numeric value equal to the total number of characters in the text specified in the "text" parameter |
| Example #1 |
Return the character count within a string Len(‘this is a test’) }} The above formula will return the number 14 Create a formula on a User entity that is set to: {{Sample| Right($email, Len($Email) - InStr($Email,'@')) The above formula will return the string after the "@" mark. For example, for the email "joe.smith@acme.com", the formula will return "acme.com", since the function Len($Email) – InStr($Email,’@’) will return the exact number of charachters to the right of the "@" |
| Tips | Review other useful text fields such as Right() and Mid() |
| Related Functions |