Removing duplicates from a variable in expression

[Sebastian_Dec]

Hi,

How can I remove duplicates from a variable in the expression?
I have variable from the user, a list od EAN separated by space.

I have two diffrent variable (I only need to remove duplicates from one)

iCodes -> a variable that takes on values ​​entered by the user, e.g.: 5907595424530 5907595425643 5907595425643 5907595424554

iCodesFormatted -> iCode variable which is formatted, with commas and quotation marks added, takes the value: "5907595424530","5907595425643","5907595425643","5907595424554"

=chr(34) & replace(iCodes, ' ', chr(34) & ',' & chr(34)) & chr(34)

I try use Aggr and concat but code in expression dont work:

=Concat(DISTINCT Aggr(Only(SubField(iCodesFormated, ' ')), SubField(iCodesFormated, ' ')), ' ')

=Concat(DISTINCT SubField(iCodes, ' '), ' ')

[Kushal_Chawda · Accepted solution]

@Sebastian_Dec  try below

=concat(distinct SubField('$(iCodes)',' ',ValueLoop(1,$(=SubStringCount(iCodes,' '))+1)),' ')

[Sebastian_Dec]

@Kushal_Chawda thank you, it works 🙂

5907595424530 5907595425643 5907595425643 5907595425643 5907595424554 5907595424530

converts to: