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,092
    Likes Received:
    3,596
    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,642
    Likes Received:
    683
    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