How to tidy up a field with comma separated values?

BillSands

I have a feature layer with bus stops on, and I've done a spatial join with a bus routes layer to add the bus route to the bus stop. I now have a field on my bus stops layer that shows the route. This field has comma separated values in.

The problem I have, is that the bus route layer has a route for each direction of the bus, which means that a but stop get's the bus route in twice.

How can I now clean out the entries for the route field, so that each route number is only shown once for each bus stop? The image below shows the route data highlighted on the right. The simplest example on there is Earlsthorpe Road, which shows "75, 75" but I'd like it to only show "75"

I hope that is clear enough. 

I should note that I am very new to ArcGIS, so go gentle with any explanation please.

Thank you.

jcarlson

You could do this with a Field Calculation. In Pro, you can do it in Python or Arcade. Here's what it would look like in Arcade, where there is a function, Distinct.

// get your routes into an array by splitting by the commas
var routes_arr = Split($feature.routes, ',') // replace "routes" with your field name

// get the distinct values
var distinct_routes = Distinct(routes_arr)

// return the distinct values, joined by commas
return Concatenate(distinct_routes, ',')