String manipulation

LEFTSTR – Select characters from left side of field

221 views June 1, 2018 admin 0

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

See also

RIGHTSTR

LENGTH

Was this helpful?