Skip to main content

 

Planview Customer Success Center

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

Len()

Left()