Any way to do this in any text editor?

Question

I have a file which is like

email = [email protected]
email = [email protected]
email = [email protected]

Can I make it like this?

email = [email protected]
email = [email protected]
email = [email protected]

Can I do this in any text editor? Or is there any other way? Thanks.

score 2 · Answer 1 · edited May 23 '17 at 11:51

I would say use Vim, but for Notepad++:

hold Alt and select the column of numbers that you wish to change. Then go to Edit->Column Editor and select the Number to Insert radio button in the window that appears. Then specify your initial number and increment, and hit OK. It should write out the incremented numbers.

copied from here.

To apply it, do it once for @gmail.com then the 1,2,3, lastly the prefix email = myemail.

I really like to recommend vim (again), you could do many stuff like these with one-liners.

yu_ominae · Answer 2 · 2012-11-05T06:19:57.770

0

Whack it into excel and write a formula to insert the row number before the @ symbol. =Substitute(YourCell, "@", Row() & "@")

EDIT:

Assuming that you have your email in cell A1, the formula would be

=SUBSTITUTE(A1,"@",ROW()&"@")

edited Nov 05 '12 at 06:19

answered Nov 05 '12 at 04:50

yu_ominae

2,975
6
39
76

im getting a weird form in excel.. any other way? – Manoj M J Nov 05 '12 at 05:29
a weird form? You should not get any form. What did you do? – yu_ominae Nov 05 '12 at 06:13

score 0 · Answer 3 · answered Nov 05 '12 at 06:07

0

SlickEdit can do with a block-selection and then an enumeration insertion.

Basically, select a vertical block before the "@", 3 lines high.

Then insert an enumeration starting at 1.

answered Nov 05 '12 at 06:07

joeking

2,006
18
29

Any way to do this in any text editor?

3 Answers3