String manipulation

REMOVEDUPLICATES – Remove duplicate values from string

250 views June 1, 2018 admin 0

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

See also

REMOVEBLANKLINES

Was this helpful?