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

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://
    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 Premium Member

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

    nonai Power Member

    Joined:
    Oct 10, 2013
    Messages:
    524
    Likes Received:
    63
    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.