How to scroll large datafile while keeping header

Question

Suppose I have some large datafile, which overflow the screen in both vertical and horizontal direction. How can I browse this file, while the header-lines stay on the screen?

For the moment, I am using less -S, so that I can nicely scroll my file horizontally and vertically. However, when scrolling down, the header lines obviously disappear. Is there a way to keep these using less?

An alternative is using vim in split-screen mode with :set nowrap. However, now if I scroll horizontally, the top window doesn't scroll in the same way (:windo set scrollbind only works for vertical scrolling as far as I know).

What do you mean by header stays visible, while the data keeps scrolling? Do you mean that you only want the first line with the column names keeps the same? Is it only one file with data and does this data keep changing and therefore you only want to see the changed rows? Do you only want to see the first N rows or last N rows? — polym, Aug 06 '14 at 16:10
@polym: less or tail -f that behave exactly like they do normally, except that the first line shown on screen would always be the header line. Like websites (or Excel) with a fixed header but scrolling body. — Mat, Aug 06 '14 at 16:12
@polym, Think of how you can freeze a horizontal and vertical view in a spreadsheet. Columns frozen stay in place while scrolling. — user208145, Mar 11 '18 at 15:58
Oh boy, that asks for an extension to less, like a Freeze Pane point. For example --freeze-pane 10,2 would keep 1 line of column headers and 10 columns row header. Horizontal and vertical scrolling would preserve the row and column headers respectively. That would be really cool to use for a psql pager (http://merlinmoncure.blogspot.com/2007/10/better-psql-with-less.html) — Gunther Schadow, Jan 17 '20 at 19:19

score 20 · Answer 1 · edited Nov 13 '15 at 21:26

20

On terminals that support setting the scrolling region:

tailf() ( # args: <file> [<number-of-header-lines>]
  trap 'tput csr 0 "$((LINES-1))"' INT
  tput csr "$((1+${2-1}))" "$((LINES-1))"
  tput clear
  {
    head -n"${2-1}"
    printf "%${COLUMNS}s\n" "" | tr ' ' =
    tail -n "$((LINES-1-${2-1}))" -f
  } < "$1"
)

(assumes a shell like zsh or bash that sets the $COLUMNS and $LINES variables based on the size of the terminal).

edited Nov 13 '15 at 21:26

Michael come lately

157

answered Aug 06 '14 at 16:31

Stéphane Chazelas

544,893

2

Dude! That is godly! Sorry, couldn't control myself. Could you direct me to webpages or commands or variables to implement the following functions? – Debanjan Basu Aug 06 '14 at 16:42
exit with q
scroll down with up and down keys

Debanjan Basu

Aug 06 '14 at 16:43

is it possible to piggyback on less itself without using head and tail to redraw the screen each time? I still <3 your solution btw. I am not marking it correct yet because you seem to be editing it and I don't want you to get complacent; complacency is a creativity-killer, I am told! :) – Debanjan Basu Aug 06 '14 at 16:47

@DebanjanBasu you can use less -X in place of tail -n ... above but the "up" key deletes the header there. – Stéphane Chazelas Aug 06 '14 at 16:49

Like I said, if you have any better ideas just point me to that, or better still please tweak your answer further. I had to mark it correct because you have answered the question that I initially asked. The idea is to have a less environment sandwiched between a header and a footer, to make it a more general tool. – Debanjan Basu Aug 06 '14 at 17:03

@DebanjanBasu, you may want to wait a couple of days before accepting the answer to encourage people to post alternatives. – Stéphane Chazelas Aug 06 '14 at 17:14

Thor · Accepted Answer · 2018-09-26T18:16:17.293

13

If you're familiar with vim, this is probably the best option for you. You can enable horizontal-scroll-bind-only by changing 'scrollopt':

set scrollopt=hor

So with vim -u NONE, you get the desired behavior with:

:set scrollopt=hor
:set nowrap
:1split
:windo set scrollbind

You may want to adjust 'sidescroll' and 'sidescrolloff' to change how many columns are skipped and how far from the edge skipping starts respectively.

edited Sep 26 '18 at 18:16

answered Jan 07 '13 at 09:59

Thor

17,182

1

Is there a way to do this with less? Especially when scrolling through enormous datafiles (too big to load into memory)? – N M May 31 '18 at 07:42
@NM: See the other answers – Thor May 31 '18 at 09:44
I tried this and when I scroll down the bottom window, the top window scrolls down too – Daniel Serodio Sep 26 '18 at 18:03
@DanielSerodio: Something seems to have changed. It works if you set scrollopt to hor, see the updated answer – Thor Sep 26 '18 at 18:17
The updated answer works as expected, thanks for the lightning fast reply :) – Daniel Serodio Sep 26 '18 at 18:21

score 6 · Answer 3 · answered Aug 06 '14 at 21:50

Try this (you'll need to install multitail):

multitail -du -t "$(head -n 1 filename)" filename

or, for headers longer than one line:

multitail -wh 2 -l "head -n 2 filename" filename

If you want to follow command output instead of a file:

multitail -wh 2 -l "command | head -n 2" -l command

or use -t as appropriate. Note that you may need to use unbuffer so your command output appears immediately.

You can use -D to disable the display of status lines for the -wh forms (it would defeat the purpose of the -t form).

score 2 · Answer 4 · answered Feb 13 '16 at 23:30

2

Thor's answer didn't mention disabling the vertical "scrollopt", which makes both windows scroll vertically. So for me the complete solution is pasting this into vim:

:set scrollopt+=hor
:set scrollopt-=ver
:set nowrap
:1split
:windo set scrollbind

answered Feb 13 '16 at 23:30

tomasz

123

You can set scrollopt directly with :scrollopt=hor or :scrollopt=hor,jump, depending on your preferences. Here's the VimDoc for scrollopt. – Michael come lately Mar 04 '16 at 18:48

score 2 · Answer 5 · edited Jul 15 '22 at 14:32

2

The bleeding edge version of less supports this with the --header option.

Less version 603 Release Notes

Version 603 was released for beta testing on 15 March 2022.

These are the differences between version 590 and version 603:

Add the --header option.

Add the --no-number-headers option.

Add the --status-line option.

...

Source: https://greenwoodsoftware.com/less/news.603.html

edited Jul 15 '22 at 14:32

muru

72,889

answered Jul 15 '22 at 14:21

Kapocsi

123

score 1 · Answer 6 · edited Mar 04 '16 at 15:55

This is as far as I got with tmux:

#!/bin/bash

tmux new-session -s main -n 'w1' -d
tmux send-keys -t main:w1.0 "tail -f <(head -n1 $1)" C-j
tmux split-window -v
tmux resize-pane -t 0 -y 2
tmux send-keys -t 1 "tail -n+2 $1|less -S" C-j
tmux attach -t main

It's an extension of user80519's answer for tmux window splitting. Save as hless.sh, make it executable and use it like

hless.sh file

score 0 · Answer 7 · answered May 28 '20 at 08:52

0

If it does not have to be a text-mode solution, you could use yad to display a list - actually a GTK+ dialog - with named columns. Maybe it has to read the whole file before you can browse, though.

answered May 28 '20 at 08:52

jarno

620

How to scroll large datafile while keeping header

7 Answers7

Linked

Related