[googlealchemist]

I've tried excel,docs,notepad++,etc to no avail. I figure there is some function in notepadd++ that can do this easily but I can't figure it out

I have a text file full of run on mashed together urls so instead of the typical nice and neat file like this:

http://www.domain1.com
http://www.domain2.com
http://www.domain3.com

I have
http://www.domain1.comhttp://www.domain2.comhttp://www.dom
ain3.com

Etc

Any ideas?

Thanks

[brandonbaker]

Find-->Replace:

.comhttp://
becomes
.com http://

Paste into Excel making each space into a new column.

[sparkplug]

I use cool notepad, so I do not know if this will work for you, but maybe you can try this:
In notepad, paste all your urls into the body of notepad. Then go to edit-replace.
In the field find what, type .com
in the field replace what, type .com<br>
Then select replace all. After you do this, it should show this:
http://www.domain1.com<br>http://www.domain2.com<br>http://www.com<br>
Then save the file as a .html file to your desktop. When you open it, it should show the urls like this:

http://www.domain1.com
http://www.domain2.com
http://www.com

This should separate everything for you. I tried it here and it work. Hopefully this will help.

[Fixer]

Similar to Pilot I think.
What I would do is find "http://" and replace with " http://" (notice the space before it).
Then click Text to Colums, and leave the first screen as delimited, click next and then tick the Space delimiter and finish.
You will have them in the columns so to get them into rows just copy the section and paste special and tick transpose (bottom right I think).

DONE!!

[akula]

Use find and replace and and make sure you choose regular expression and find on the "http://" replace with "\n http://". That should put them all on their own line.

Its something like that. I dont have access to notepad ++ right now to make sure there is nothing else I am forgetting.

Edited by akula, 17 February 2012 - 17:51.

[krish]

Just rename the text file with a .html extension instead of .txt. Install Web Developer Addon for Firefox. Open the file in firefox. Go to "Information" > "View Link Information". It will open new tab with links on page only. All other text and images will be removed.

Edited by krish, 18 February 2012 - 04:17.

[googlealchemist]

God dang, i'm surrounded by genius! Thanks to all the recs guys

[Fixer]

googlealchemist, on 21 February 2012 - 12:04, said:

God dang, i'm surrounded by genius! Thanks to all the recs guys

Ha, wouldn't go that far, excel geek yes lol!!