Grr annoying URL list

str8thustler · Sep 17, 2010

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?

matt1972 · Sep 17, 2010

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.

MisterTwister · Sep 17, 2010

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,

HoNeYBiRD · Sep 17, 2010

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.

str8thustler · Sep 18, 2010

problem is they are profile link urls and have numbers and letters in the URLS

Hunwarrior · Sep 18, 2010

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

paincake · Sep 18, 2010

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.)

HoNeYBiRD · Sep 18, 2010

paincake said:
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.)

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

paincake · Sep 18, 2010

HoNeYBiRD said:
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

Make sure you have the exact same settings and click "replace all"

HoNeYBiRD · Sep 18, 2010

paincake said:
Make sure you have the exact same settings and click "replace all"

lol, it worked finally

, simplest way ever, but you forgot to mention this little detail previously :spank:

Kid Shaleen · Sep 18, 2010

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.

Grr annoying URL list

str8thustler

Power Member

matt1972

Power Member

MisterTwister

Regular Member

HoNeYBiRD

Elite Member

str8thustler

Power Member

Hunwarrior

Senior Member

paincake

Power Member

HoNeYBiRD

Elite Member

paincake

Power Member

HoNeYBiRD

Elite Member

Kid Shaleen

BANNED

Main Menu

Marketplace

Making Money

BlackHat World