String manipulation

UNIQUESTR – Return unique entries in a given string

84 views June 1, 2018 admin 0

Overview

This Custom Field returns the unique entries in a given string.

Syntax

UNIQUESTR(FIELDSTR(HTML),#,)

Element Description
InputString The string to check.
InputSeparator The separators in the input string.
OutputSeparator The separators to use in the input string.

Example

Where FIELDSTR(Manufacturer) is Toyota#Ford#Holden#Ford#Mazda#Holden#Ford#Hyundai#Hyundai#Ford

UNIQUESTR(FIELDSTR(Manufacturer),#,) will return:

Toyota-Ford-Holden-Mazda-Hyundai

See also

LEFTSTR

RIGHTSR

PARTSTR

TRUNCATESTR

Was this helpful?