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.

< All Topics
Print

PARTSTR – Extract part of delimited list

Overview

This Custom Field extracts part of a delimited list such as ‘a,b,c’ or ‘banana; pear; apple’.

Syntax

PARTSTR(FieldName, Index (starting at 0), Delimiter)

Element Description
FieldName List of values
Index Address of target (starting at zero)
Delimiter Character(s) used to separate list

Example

PARTSTR(‘banana; pear; apple‘, 0, ‘;‘) returns banana.

PARTSTR(‘yellow or green; blue, orange, red; brown‘, 1, ‘;‘) returns blue, orange, red.

PARTSTR(‘CD01023, CJ10354, CK12893‘, 0, ‘,‘) returns CD01023.

See also

 

 

Table of Contents