How to bulk edit urls?

Discussion in 'Black Hat SEO' started by belgianguy, Apr 25, 2014.

  1. belgianguy

    belgianguy Registered Member

    Joined:
    Oct 7, 2010
    Messages:
    76
    Likes Received:
    13
    I'm looking for a tool that lets me bulk edit urls. I have about a list of thousand urls that look like this:
    http://
    www.arandomwebsite . com/a-page&refurl=http://www.anotherurl.com

    What is the easiest way to strip the &refurl=http://www.anotherurl.com from the url? Is there a tool that can do this?

    Thanks in advance!


     
  2. brexilator

    brexilator Newbie

    Joined:
    Mar 30, 2014
    Messages:
    9
    Likes Received:
    1
    You could use excel with the split data function, put & where it asks the character to split by.
     
  3. DarkPixel

    DarkPixel Jr. VIP Jr. VIP

    Joined:
    Oct 4, 2011
    Messages:
    1,348
    Likes Received:
    1,256
    Location:
    ↓↓↓↓
    Home Page:
    Notepad++ with Regex replace should work well.
     
  4. nonai

    nonai Power Member

    Joined:
    Oct 10, 2013
    Messages:
    524
    Likes Received:
    64
    paste all to notepad++
    control F
    find &refur
    replace with tab character
    replace all
    control A to select all
    open excel, paste

    Now you should have 2 columns. column A is what you want. column B is all the garbage.