Need to remove duplicate values under list collector field "Can Read" in knowledge table

[Harsha M V]

Hi All,

How do we remove duplicate values under list collector field "Can Read" in knowledge table.
There are 2000+ articles where a field "Can Read" has multiple duplicate values added somehow.

How to write a script and cleanup the duplicate values for the field "Can Read" and have only unique values.
Sample picture attached

Please help with the script.

[Dan Ostler]

A Glide List field can contain more than one reference to the same object. While this is can only be done when the Glide List field is populated or updated via a script is it still possible and not an uncommon bug.

As the underlying value of a Glide List field is a comma separated string of sys_id's true duplicate values would mean that the list field contains the same sys_id more than once. That would not indicate that there are two objects in the referencing table with the same display value.