Right Function
Right (text as String, charsLength as Numeric) as String
| Category: | Text |
| Description: | Returns the specific number of characters beginning from the righthand side of 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 |
| charsLength as Numeric | Positive or negative numeric value or reference to a numeric field, to which you would like to get the text to the right of the character number |
| Returned value as String | Returns a text or string value equal to the text to the right of the character number specified in "charsLength" |
| Example #1 |
Create a custom formula on a User entity that will return the string after the "@" mark. So for example, for an email "joe.smith@acme.com" the formula will return "acme.com" Right($email,Len($Email)-InStr($Email,'@')) |
| Tips | Review other useful related text functions, such as Len() and Left() |
| Related Functions |