topic Remove duplicates from a joined string in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/remove-duplicates-from-a-joined-string/m-p/1053109#M34259 <P>Hi,</P><P>Hoping someone can help...</P><P>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><P>P_12567</P><P>P_12568</P><P>P_12569</P><P>P_12567</P><P>Which I would want to make into a single string of:</P><P>'P_12567 P_12568 P_12569' - so the duplicated P_12567 is ignored</P><P>Many thanks in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 30 Apr 2021 10:38:56 GMT GeomaticsPublisher 2021-04-30T10:38:56Z Remove duplicates from a joined string https://community.esri.com/t5/arcgis-survey123-questions/remove-duplicates-from-a-joined-string/m-p/1053109#M34259 <P>Hi,</P><P>Hoping someone can help...</P><P>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><P>P_12567</P><P>P_12568</P><P>P_12569</P><P>P_12567</P><P>Which I would want to make into a single string of:</P><P>'P_12567 P_12568 P_12569' - so the duplicated P_12567 is ignored</P><P>Many thanks in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 30 Apr 2021 10:38:56 GMT https://community.esri.com/t5/arcgis-survey123-questions/remove-duplicates-from-a-joined-string/m-p/1053109#M34259 GeomaticsPublisher 2021-04-30T10:38:56Z Re: Remove duplicates from a joined string https://community.esri.com/t5/arcgis-survey123-questions/remove-duplicates-from-a-joined-string/m-p/1054699#M34365 <P>I think a javascript function is your only way.&nbsp; Or post processing.</P> Wed, 05 May 2021 15:26:44 GMT https://community.esri.com/t5/arcgis-survey123-questions/remove-duplicates-from-a-joined-string/m-p/1054699#M34365 DougBrowning 2021-05-05T15:26:44Z