Link catharsis?

Hi!

I have scrapped URL's through Scrapebox and unfortunately I have saved them like this in text file:

"http://asia.cnn.com/1999/TECH/computing/12/02/home.theater.idg/index.html","0","0","Completed"
"http://no.tripadvisor.com/Hotel_Review-g190492-d4345632-Reviews-Scandic_Kristiansand_Bystranda-Kristiansand_Vest_Agder_Southern_Norway.html","0","176","Completed"
"http://energy.gov/articles/producing-natural-gas-shale","5","188","Completed"
"http://gizmodo.com/5022102/the-godfather-box-set-going-blu","54","61","Completed"

Anyone know how to delete these unwanted lines to make it clear?

Thanks!

Open up the document on notepad ++ and use the find and replace function (ctrl+f) and replace everything you do not want with spaces.

^^ this will be time consuming in this case because each line to be removed is unique.

This will be faster:

Copy into notepad.
Save as a text file called fixthis.txt.
Rename the text file from fixthis.txt to fixthis.csv.
Open the fixthis.csv file in excel.
Copy only the column with the url.

♪ ♫ TA DAA ♫ ♪

I use the find and replace functions in MS Word to resolve similar issues as this.

Techxan said:

^^ this will be time consuming in this case because each line to be removed is unique.

This will be faster:

Copy into notepad.
Save as a text file called fixthis.txt.
Rename the text file from fixthis.txt to fixthis.csv.
Open the fixthis.csv file in excel.
Copy only the column with the url.

♪ ♫ TA DAA ♫ ♪

Click to expand...

This one worked for me. I have changed some settings while loading txt file and then it all sorted in separate columns. Thank you so much .