What I mean is that I want to create a list of company names out of all the names that appear in the links.
So if I have these links:
Link 1 company- LG,Sony
Link 2 company-,Sony
Link 3 company- LG
Link 4 company- Toshiba ,Sony
The list will show:
LG
Sony
Toshiba
But right now when one link has two company names it reads both names and the comma between them like a new name so I get this list, with a lot of repetitions
LG,Sony
Sony
LG
Toshiba ,Sony
What I want is that it will know that the comma (or enter) separates two different names that should appear separately on the company name list, and to cancel the repetitions.
So if I have these links:
Link 1 company- LG,Sony
Link 2 company-,Sony
Link 3 company- LG
Link 4 company- Toshiba ,Sony
The list will show:
LG
Sony
Toshiba
But right now when one link has two company names it reads both names and the comma between them like a new name so I get this list, with a lot of repetitions
LG,Sony
Sony
LG
Toshiba ,Sony
What I want is that it will know that the comma (or enter) separates two different names that should appear separately on the company name list, and to cancel the repetitions.