Notepad ++ How to remove lines from to from

[mindmaster]

I have a 1.200.000 lines.

How can I remove lines from 1 to 1.000.000 with notepad++ or other?

I need this for scrapebox, as it doesn't let me import list bigger than 1 million.

Appreciated.

 

[mindmaster]

bumpy bump

 

[Frogserv]

Use search & replace with regex.

 

[schwarz]

How can I remove lines from 1 to 1.000.000 with notepad++ or other?

Never used notepad++, but with vim (DL: vim.org) it's really simple...
Open the file, then make sure, you are in the "command mode" (if unsure, then press ESC), then
Go to the first line:

:1 [ENTER]

Delete the first 1,000,000 lines:

d1000000 [ENTER]

Save the file:
:w [ENTER]

If something goes wrong... (undo):
:u [ENTER]

Hope this helps.

 

[_Chip_]

I am not sure about notepad++...
but ...paste all in excel...
drag the scrol bar to 1 millionth line ...
select the 1 millionth line,
now press ctrl + shift + home
delete...
now goto 1.000.001 th line ..
press ctrl + shift + end ...
copy >> paste in your text file

 

[mindmaster]

Use search & replace with regex.

I read about it but can't figure what's the specific code for regex.

 

[kazhkaz]

I am not sure about notepad++...
but ...paste all in excel...
drag the scrol bar to 1 millionth line ...
select the 1 millionth line,
now press ctrl + shift + home
delete...
now goto 1.000.001 th line ..
press ctrl + shift + end ...
copy >> paste in your text file

Doesn't excel have 65k line limit?

 

[Frogserv]

I am not sure about notepad++...
but ...paste all in excel...
drag the scrol bar to 1 millionth line ...
select the 1 millionth line,
now press ctrl + shift + home
delete...
now goto 1.000.001 th line ..
press ctrl + shift + end ...
copy >> paste in your text file

Previous version of Excel will not work I think.
There was a limit to the number of lines

 

[mindmaster]

Doesn't excel have 65k line limit?

Previous version of Excel will not work I think.
There was a limit to the number of lines

Yes with excel doesn't work.

Can you tell me the regex code for this?

 

[mindmaster]

Never used notepad++, but with vim (DL: vim.org) it's really simple...
Open the file, then make sure, you are in the "command mode" (if unsure, then press ESC), then
Go to the first line:

:1 [ENTER]

Delete the first 1,000,000 lines:

d1000000 [ENTER]

Save the file:
:w [ENTER]

If something goes wrong... (undo):
:u [ENTER]

Hope this helps.

Great little soft.

Worked in 2 seconds.

Rep

 

[ekologic]

or you can write a macro in notepad++ then you can specify to repeat that macro n times.
write a macro which would delete a line then play at as much as you want

 

[Narrator]

I use HJ-Split to split up large files. Try googling it.

 

[_Chip_]

Doesn't excel have 65k line limit?

Yes with excel doesn't work.

Can you tell me the regex code for this?

who said excel can only support 65k lines? :O
are you people still using microsoft excel XP ? :\

 

[Knoxgates]

Doesn't excel have 65k line limit?

65k line restriction is in office 2003. Office 2007 supports 1 million lines

 

[mindmaster]

or you can write a macro in notepad++ then you can specify to repeat that macro n times.
write a macro which would delete a line then play at as much as you want

Yes this is an idea.
However I managed to do it quick with wim. Great little software.

I use HJ-Split to split up large files. Try googling it.

Is it able to split certain numbers of lines or just file size?

who said excel can only support 65k lines? :O
are you people still using microsoft excel XP ? :\

65k line restriction is in office 2003. Office 2007 supports 1 million lines

Don't know if it can take it or not, it crashed 2 times trying to paste 1,3 million lines.

I saved the VIM . org software for future use.

 

[Gradimir Stankovic]

Can't you just go to first line, select it, go to millionth line, hit shift and select it all? After that just cut or delete it, and there you go.

 

[seeplusplus]

Is there a need for such a tool? I could create one in C++ pretty quickly.

 

[mindmaster]

Is there a need for such a tool? I could create one in C++ pretty quickly.

No need.

Problem solved.

 

[Baybo.it]

I'm really happy people are posting vim and emacs shortcuts -- they're really great editors. One good solution (which isn't ideal) would be to use Control + Shift + Up-Key to move a line up or Control + Shift + Up-Down to move the line down.

Of course, as was suggested, vim and emacs have much nicer command bindings for common tasks like these, and the macro systems are gorgeous. Hope this helps!