Skip to main content
Planview Customer Success Center

Left Function

Left (text as String, charsLength as Numeric) as String

Category: Text
Description: Returns the specific number of characters beginning from the lefthand 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 left of the character number
Returned value as String Returns a text or string value equal to the text to the left of the character number specified in "charsLength"
Example #1

Create a custom field on a user entity that will return the string of an email address up to the "@" mark, so for example, for the email "joe.smith@acme.com" the formula will return "joe.smith"

Left($email,InStr($Email,'@')-1)