String manipulation

RIGHTSTR – Select characters from right side of field

171 views June 1, 2018 admin 0

Overview

This returns a specified number of characters from the right side of a field.

Syntax

RIGHTSTR(FieldName,’N‘)

Element Description
FieldName The name of the field from which to extract characters.
N The number of characters to extract.

Example

RIGHTSTR (Manufacturer,5)

Manufacturer

RIGHTSTR (Manufacturer,5)

Ford Motor Company mpany

RIGHTSTR (Manufacturer,3)

Manufacturer

RIGHTSTR (Manufacturer,3)

Ford Motor Company any

See also

LEFTSTR

LENGTH

Was this helpful?