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