String manipulation

PARTSTR – Extract part of delimited list

251 views June 1, 2018 admin 1

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

 

 

Was this helpful?