1) I took your list of all names in "raw" text
https://f95zone.to/threads/vam-look-a-pedia-reverse-search-list.258914/
2) Gave ChatGPT a part of the text and said "I need an algorithm that reassembles this text into the table "name" -> "link"
3) I took it from the website
You must be registered to see the links
the same data (if I'm not mistaken, I also converted it to the desired format)
4) I inserted two ready-made tables into Excel and clicked "delete duplicates". That's the result
Why didn't I just give out all the ChatGPT and tell them to do it myself? He didn't do very well in this