How to remove the numbering from a huge list?

R

rulingim

Newbie

Apr 4, 2012

17

14

• Nov 2, 2012

• #1

I have a list of sites which I want to import in my software but there is a problem. In the text file the urls in the format of

1. {url here)
2. {url here}
....
..
..

So how can I remove the numbers to the left?

 

L

lord_

Newbie

Jan 28, 2009

3

2

• Nov 2, 2012

• #2

Replace all spaces for tabs then paste on excel and you have it separated in columns

 

Eagle Eye

Senior Member

Aug 3, 2010

1,122

656

• Nov 2, 2012

• #3

use notepad++

you will also have to download the plugin "texteffects" i think it is called

 

R

rulingim

Newbie

Apr 4, 2012

17

14

• Nov 2, 2012
• Thread Starter Thread Starter

• #4

lord_ said:

Replace all spaces for tabs then paste on excel and you have it separated in columns

Click to expand...

aah got it..Thanks a lot!

 

G

golface72

Regular Member

Nov 1, 2011

343

127

• Nov 2, 2012

• #5

For future reference text pad macros do stuff like that well. They can take a couple minutes to execute through late files but you can make them do pretty much anything

 

Fripper

Regular Member

Jan 8, 2012

416

143

• Nov 2, 2012

• #6

lord_ said:

Replace all spaces for tabs then paste on excel and you have it separated in columns

Click to expand...

Yep this is what I usually do, it works like a charm.
Sometimes you can paste it in excel directly and then just copy the second column.