String manipulation

SUBSTR – Select string of characters in a field

111 views June 1, 2018 admin 0

Overview

This Custom Field extracts specific characters from another field.

Syntax

SUBSTR(FieldName,IndexStart,Length)

SUBSTR(Description,3,4)

 

Element Description
FieldName The name of the field from which to extract characters.
IndexStart The index of the first character, starting at 0.
Length The number of characters to extract.

Examples

SUBSTR (Manufacturer,5,5)

Manufacturer

SUBSTR (Manufacturer,5,5)

Ford Motor Company Motor
Toyota a
Mercedes-Benz des-B

SUBSTR (Manufacturer,4,3)

Manufacturer

SUBSTR (Manufacturer,4,3)

Ford Motor Company Mo
Toyota ta
Mercedes-Benz ede

See also

LEFTSTR

RIGHTSTR

LENGTH

Was this helpful?