Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
REMOVEDUPLICATES – Remove duplicate values from string
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‘