String manipulation

PARTSTR – Extract part of delimited list

559 views June 1, 2018 admin 1


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


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


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



Was this helpful?