Remove duplicates from a joined string

179
1
04-30-2021 03:38 AM
GeomaticsPublisher
New Contributor III

Hi,

Hoping someone can help...

I've got upto 12 fields with string values that I want to join together into a single string. I can use concatenate or join to do this however some of the fields have duplicate values. Is there a way to remove duplicates from the joined string? example of inputs might be:

P_12567

P_12568

P_12569

P_12567

Which I would want to make into a single string of:

'P_12567 P_12568 P_12569' - so the duplicated P_12567 is ignored

Many thanks in advance :)

0 Kudos
1 Reply
DougBrowning
MVP Notable Contributor

I think a javascript function is your only way.  Or post processing.

0 Kudos