I have a table that contains a number of fields containing a list of countries. Some of them are duplicates. For example:
ITALY , GERMANY , FRANCE , GERMANY , BULGARIA , ITALY , ITALY , GERMANY , BELGIUM , SOUTH AFRICA , ITALY , UNITED KINGDOM
I want to scan the file and remove the duplicate countries so that it would read something like this:
ITALY , GERMANY , FRANCE , BULGARIA , BELGIUM , SOUTH AFRICA , UNITED KINGDOM
I'm being stupid and cannot think of an easy way to do this.
Can someone please suggest something?