Splitting numbers and removing duplicates in a text string

[SimonCrutchley]

Hi there,

Some time ago people helped me with a similar issue where I wanted to split textual data in a string

https://community.esri.com/t5/mapping-questions/splitting-data-in-an-attribute-table/m-p/1008011#M82...

I'm trying to do the same thing with figures relating to areas, but possibly because these are numeric they behave differently. Running the code on 285311,285311,11540,11540 gives me the answer 11540285311, where what I really want is 285311, 11540.

I'm sure there's a simple solution, but looking at the https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/calculate-field-examples.htm hasn't helped.

Thanks

[DavidSolari]

Dang, looks like I missed that note when they changed the implementation, good catch!

[SimonCrutchley]

Hi folks,

Thanks to you both. I've tried both techniques and they work.

Cheers

[JoshuaBixby]

@SimonCrutchley , as an FYI, you can mark multiple responses as a solution if multiple responses work for you.