Table of Contents
Overview
This returns a specified number of characters from the left side of a field.
Syntax
LEFTSTR(FieldName,n)
| Element | Description |
|---|---|
| FieldName | The name of the field from which to extract characters. |
| n | The number of characters to extract. |
Example
LEFTSTR (Manufacturer,5)
| Manufacturer |
LEFTSTR (Manufacturer,5) |
| Ford Motor Company | Ford |
In the above example, the character count of 5 includes the space after ‘Ford’ as the fifth character.
LEFTSTR (Manufacturer,3)
| Manufacturer |
LEFTSTR (Manufacturer,3) |
| Ford Motor Company | For |