GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Removing duplicate lines in text file by php or excel?

mkx · 01-08-2008, 08:46 PM

I have a txt file that looks something like this

John
John
John
Peter
Fred
Fred
Paul
Paul
Paul
Paul

It's over 5,000 lines long, I was wondering if someone can post a quick php script or info of how to remove duplicate lines in excel so it looks like this:

John
Peter
Fred
Paul

Hope someone can help

01-08-2008, 08:46 PM
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	Removing duplicate lines in text file by php or excel? I have a txt file that looks something like this John John John Peter Fred Fred Paul Paul Paul Paul It's over 5,000 lines long, I was wondering if someone can post a quick php script or info of how to remove duplicate lines in excel so it looks like this: John Peter Fred Paul Hope someone can help