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 🙂
I think a javascript function is your only way. Or post processing.