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 |