Remove Duplicates within Concatenated Cells

[kat_osborn]

Hi. I am trying to remove duplicates from a concatenated cell. I am using a summarize tool to concatenate and using \n as the separator in order to have the concatenated fields have each one on a separate line.

Is there a simple way to remove the duplicates? 

Thank you!

[mceleavey]

Hi @kat_osborn ,

Can you please post some data as an example?

M.

[kat_osborn]

Here is a very vague example of what I am looking at. Let me know if you are needing anything more. @mceleavey 

[mceleavey]

Hi @kat_osborn ,

I'm assuming the example you gave was AFTER you've done the work described above? So this is after you've concatenated? If that's the case why not simply use a unique tool before the Summarise tool?

Do you have an example of the data BEFORE you concatenate? Is there a reason you're concatenating with the duplicates THEN trying to remove it?

M.

[kat_osborn]

Yes, this is after they have been concatenated. The unique tool is not working before the summarize tool for some reason. I did not know if there was a way to do it after. There's no reason as to why, that's why I was asking if it was possible. 

[binuacs]

@kat_osborn Something like this?