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

Grr annoying URL list

Discussion in 'Link Building' started by str8thustler, Sep 17, 2010.

  1. str8thustler

    str8thustler Power Member

    Joined:
    Dec 3, 2008
    Messages:
    669
    Likes Received:
    243
    Occupation:
    ClientMAX Marketing
    Location:
    Philly
    Home Page:
    Ok, so I have a url list with 6000 urls. I want to create an rss feed, problem being they are all numbered in the front of them, IE
    1. Http://sdfsdfsd
    2. http://dsfgdfgfd

    can anyone tell me what is the simplest way to remove all the numbers without doing it by hand?
     
  2. matt1972

    matt1972 Regular Member

    Joined:
    Nov 19, 2009
    Messages:
    499
    Likes Received:
    206
    Occupation:
    To make money
    Location:
    192.168.0.1
    Sure, easy.. if you have Notetab Pro or another text editor that will search for non printing characters. I use Notetab Pro for things like this.. you can get a trial version at:

    Code:
    http://www.notetab.com/downloads.php
    Just search for: http:// and replace it with ^Thttp://

    What that does is find all of your http:// and replaces them with a tab http://. Then you can save it and open it in Excel or a spreadsheet program and seperate by tab and there ya go.. all your links will be in one column without numbers.
     
    • Thanks Thanks x 2
  3. MisterTwister

    MisterTwister Regular Member

    Joined:
    Feb 12, 2009
    Messages:
    458
    Likes Received:
    160
    Paste the list into word then use the replace function to remove all the numbers.

    Put this in the find box ^#.

    Leave the replace box blank,
     
    • Thanks Thanks x 1
  4. HoNeYBiRD

    HoNeYBiRD Jr. VIP Jr. VIP

    Joined:
    May 1, 2009
    Messages:
    5,875
    Likes Received:
    7,115
    Gender:
    Male
    Occupation:
    Geographer, Tourism Manager
    Location:
    Ghosted
    you can use this lightweight offline html tool what i posted here for extracting webaddresses and email addresses as well:
    Code:
    http://www.blackhatworld.com/blackhat-seo/1742232-post2.html
    it can do the trick in a sec:
    copy-paste your list into the tool, select the type of address: webaddress and select a separator: comma, new line etc.
     
    • Thanks Thanks x 1
  5. str8thustler

    str8thustler Power Member

    Joined:
    Dec 3, 2008
    Messages:
    669
    Likes Received:
    243
    Occupation:
    ClientMAX Marketing
    Location:
    Philly
    Home Page:
    problem is they are profile link urls and have numbers and letters in the URLS
     
  6. Hunwarrior

    Hunwarrior Jr. VIP Jr. VIP Premium Member

    Joined:
    May 12, 2010
    Messages:
    1,027
    Likes Received:
    859
    notepad++

    select all http: and cahnge them to ;http:

    open the new file in excell, make the separatort ";" so you will have the numbers in row1, urls in row2. delet row1.

    here you go ;)

    ps: how many times i have to tell you guys.... Notepad++ + imacros FF plugin ;) and you spam the shit out of the universe ;)
     
  7. paincake

    paincake Power Member

    Joined:
    Aug 18, 2010
    Messages:
    716
    Likes Received:
    3,099
    Home Page:
    Put this into 'search' field:
    Code:
    [0-9]+\.
    and nothing into 'replace' field, so it replaces it with nothing.

    I'm not sure if it will work with other programs mentioned here, but it will work with notepad++ (I highly recommend it, it has other very useful stuff, like removing empty lines, all kind of formatting etc.)
     
    Last edited: Sep 18, 2010
  8. HoNeYBiRD

    HoNeYBiRD Jr. VIP Jr. VIP

    Joined:
    May 1, 2009
    Messages:
    5,875
    Likes Received:
    7,115
    Gender:
    Male
    Occupation:
    Geographer, Tourism Manager
    Location:
    Ghosted
    yea, Notepad++ all the way, but what you wrote, it's not working, i've just tried that
    and i'm almost sure, it can be done using only Notepad++ without using Excel or any other program, if somebody can write a macro in Notepad++, although i haven't tried it yet, but i guess it can be done
     
  9. paincake

    paincake Power Member

    Joined:
    Aug 18, 2010
    Messages:
    716
    Likes Received:
    3,099
    Home Page:
    Make sure you have the exact same settings and click "replace all"

    [​IMG]
     
    • Thanks Thanks x 1
    Last edited: Sep 18, 2010
  10. HoNeYBiRD

    HoNeYBiRD Jr. VIP Jr. VIP

    Joined:
    May 1, 2009
    Messages:
    5,875
    Likes Received:
    7,115
    Gender:
    Male
    Occupation:
    Geographer, Tourism Manager
    Location:
    Ghosted
    lol, it worked finally :D, simplest way ever, but you forgot to mention this little detail previously :spank:
     
  11. Kid Shaleen

    Kid Shaleen Regular Member

    Joined:
    Oct 29, 2009
    Messages:
    250
    Likes Received:
    63
    I've been working with the same thing all day yesterday.

    I've found this is best: use the column edit feature in notepad++. Put the cursor where you want to start. Press and hold down the ALT key. Drag the mouse over to the right through the characters you want to zap. Then drag it down the column to the bottom. Finally, just hit DEL.

    Quick. Easy. Efficient.