String manipulation

DISTINCTLIST – Create unique list of values

163 views June 1, 2018 admin 1

Overview

This Custom Field creates a list of unique values based on a set of parameters.

Syntax

DISTINCTLIST(‘,‘, FIELDSTR(Field A), FIELDSTR(Field B))

 

Element Description
Separator The delimiter separating the values
FIELDSTR(Field A) String contents

Example

1. For the table

Shape
Round
Round
Square

DISTINCTLIST(‘,‘, FIELDSTR(Shape A), FIELDSTR(Shape B), FIELDSTR(Shape C))

will return

Round, Square

2. For the table

Shape
Round
Triangular
Square
Triangular
Round

DISTINCTLIST(‘;‘, FIELDSTR(Shape A), FIELDSTR(Shape B), FIELDSTR(Shape C), FIELDSTR(Shape D),FIELDSTR(Shape E))

will return

Round; Triangular; Square

See also

FIELDSTR

Was this helpful?