Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I guess everyone knows the useful Linux cmd line utilities head and tail. Head allows you to print the first X lines of a file, tail does the same but prints the end of the file. What is a good command to print the middle of a file? something like middle --start 10000000 --count 20 (print the 10,000,000th till th 10,000,010th lines).

I'm looking for something that will deal with large files efficiently. I tried tail -n 10000000 | head 10 and it's horrifically slow.

Thanks, Boaz

share|improve this question
4  
possible duplicate of serverfault.com/questions/101900/… –  Kyle Brandt Apr 19 '10 at 12:20
add comment

5 Answers 5

up vote 31 down vote accepted
sed -n '10000000,10000020p' filename

You might be able to speed that up a little like this:

sed -n '10000000,10000020p; 10000021q' filename

By the way, your command

tail -n 10000000 filename | head 10

starts at the ten millionth line from the end of the file, while your "middle" command would seem to start at the ten millionth from the beginning which would be equivalent to:

head -n 10000010 filename | tail 10

The problem is that for unsorted files with variable length lines any process is going to have to go through the file counting newlines. There's no way to shortcut that.

If, however, the file is sorted (a log file with timestamps, for example) or has fixed length lines, then you can seek into the file based on a byte position. In the log file example, you could do a binary search for a range of times as my Python script here* does. In the case of the fixed record length file, it's really easy. You just seek linelength * linecount characters into the file.

* I keep meaning to post yet another update to that script. Maybe I'll get around to it one of these days.

share|improve this answer
    
Here is a sed version of Charles' middle function: middle() { local s=$1 c=$2; shift 2; sed -n "$s,$(($s + $c -1))p; $(($s + $c))q" "$@"; }. It will handle multiple file arguments, filenames with spaces, etc. Multiple files are processed together as if they had been catted in the same way that sed normally does (so middle 1000 100 file1 file2 would span across the end of the first file to the beginning of the second one if the first one has fewer than 1100 lines). –  Dennis Williamson Apr 19 '10 at 15:55
    
The function in my previous comment can be called with a filename parameter: middle startline count filename or multiple filenames: middle startline count file1 file2 file3 or with redirection: middle startline count < filename or in a pipe: some_command | middle startline count` or cat file* | middle startline count –  Dennis Williamson Apr 20 '10 at 16:47
    
Shouldn't the ` in your sed command be a '? I can't get it to work with the backtick but it works fine with the single quote. –  Ian Hunter Dec 18 '12 at 21:51
    
@beanland: Yes, it's a typo. I've fixed it. Thanks. –  Dennis Williamson Dec 19 '12 at 5:57
    
@DennisWilliamson: tail -n 10000 print the last 10000 lines. use tail -n +10000 to start print at 10000th line. –  Gnouc May 23 at 12:16
add comment

I found out the following use of sed

sed -n '10000000,+20p'  filename

Hope it's useful to someone!

share|improve this answer
add comment

Dennis' sed answer is the way to go. But using just head & tail, under bash:

middle () { head -n $[ $1 + $2 ] | tail -n $2; }

This scans the first $1+$2 lines twice, so is much worse than Dennis' answer. But you don't need to remember all those sed letters to use it....

share|improve this answer
    
Using $[...] is deprecated, at least in Bash. Also, you're missing a file parameter. –  Dennis Williamson Apr 19 '10 at 15:46
    
@Dennis: No missing parameter: you're meant to use this on stdin, as per middle 10 10 < /var/log/auth.log. –  Charles Stewart Apr 20 '10 at 16:33
add comment

This is my first time posting here! Anyway, this one is easy. Let's say you want to pull line 8872 from your file called file.txt. Here is how you do it:

cat -n file.txt | grep '^ *8872'

Now the question is to find 20 lines after this. To accomplish this you do

cat -n file.txt | grep -A 20 '^ *8872'

For lines around or before see the -B and -C flags in the grep manual.

share|improve this answer
    
While that is technically correct and an interesting way to do it on a reasonably-sized file, I'm curious about its efficacy when working with files of the size the poster is asking about. –  Jenny D May 23 at 12:37
add comment

A ruby oneliner version.

ruby -pe 'next unless $. > 10000000 && $. < 10000020' < filename.txt

It can be useful to somebody. The solutions with 'sed' provided by Dennis and Dox is very nice, even because it seems faster.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.