1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Link catharsis?

Discussion in 'Black Hat SEO' started by Neavon, Sep 2, 2014.

  1. Neavon

    Neavon Registered Member

    Joined:
    May 14, 2014
    Messages:
    75
    Likes Received:
    16
    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!
     
  2. Almenocinque

    Almenocinque Junior Member

    Joined:
    Dec 3, 2013
    Messages:
    122
    Likes Received:
    30
    Location:
    Nan Yanoi
    Open up the document on notepad ++ and use the find and replace function (ctrl+f) and replace everything you do not want with spaces.
     
  3. Techxan

    Techxan Elite Member

    Joined:
    Dec 7, 2011
    Messages:
    3,093
    Likes Received:
    3,585
    Occupation:
    Local SEOist
    Location:
    TEXAS (you have to yell, its the law.)
    ^^ 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 ♫ ♪
     
    • Thanks Thanks x 2
  4. SEO Power

    SEO Power Elite Member

    Joined:
    Jul 14, 2014
    Messages:
    2,637
    Likes Received:
    680
    Occupation:
    Self employed
    Location:
    Houston, TX
    I use the find and replace functions in MS Word to resolve similar issues as this.
     
  5. Neavon

    Neavon Registered Member

    Joined:
    May 14, 2014
    Messages:
    75
    Likes Received:
    16
    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 ;).
     
    • Thanks Thanks x 1