Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
SUBSTR – Select string of characters in a field
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 |