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.

< All Topics
Print

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

See also

REMOVEBLANKLINES

Table of Contents