Syntax: Left ( text; numberOfCharacters )
textAny expression that resolves to a text string.
numberOfCharactersAny expression that resolves to a positive integer.
Data type returned: Text
Returns a string containing the first n characters from the specified text string, where n is the number specified in the numberOfCharacters parameter. If the string is shorter than numberOfCharacters, the entire string is returned. If numberOfCharacters is less than 1, an empty string is returned.
The Left() function is commonly used in text parsing routines to extract portions of a text string. It is often used in conjunction with other text functions. For example, to extract the City portion of a field (called "CSZ") containing "City, State Zip" data, you could use the following formula:
Let (commaPosition = Position (CSZ; ","; 1; 1); Left (CSZ; commaPosition - 1))
Left ("Hello"; 2)
Left (FirstName; 1)
Returns the first character of the FirstName field.
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information