Table of Contents
Overview
This Custom Field removes duplicate values from a given string.
Syntax
REMOVEDUPLICATES(Separator,String)
REMOVEDUPLICATES(‘;’,‘A;B;C;A;D;E’)
| Element | Description |
|---|---|
| Separator | The value separator, e.g. ‘;’ or ‘,’. |
| String | A string of delimited values. |
Examples
REMOVEDUPLICATES(‘;’,‘A;B;C;A;D;E’) will return ‘A;B;C;D;E‘.
REMOVEDUPLICATES(‘,’,‘Tom,Dick,Dick,Harry,Dick,Tom,Harry’) will return ‘Tom,Dick,Harry‘