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) |