Table of Contents
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 |