5

Sort lines based on a column in Vim/Nvim

 3 years ago
source link: https://jdhao.github.io/2021/12/21/sort_lines_based_on_a_column_nvim/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

Sort lines based on a column in Vim/Nvim

2021-12-21224 words 2 mins read 116 times read

I have a file where each line has several comma-separated items. I want to sort the lines, based on a certain column. How do we do it inside Vim/Nvim?

There are two different ways to achieve this.

Using external sort

The first is via external tool sort and the vim filter feature (see :help filter). The syntax is:

:{range}!{filter}

Lines in the given {range} are sent to external program and are replaced with the output of external command.

For example, to sort the following lines based on the 3rd column:

adf,adf,0.56
dkkdf,iwer,0.23
uywe,qwe,0.4
mckdf,adfj,0.35

we can use the following vim command:

:%!sort -t, -k3
" or use the following
" :1,$!sort -t, -k3

Using :sort command

The second method is to use the vim builtin :sort command (see :h :sort for the details).

:sort f /^.*,.*,/

Explanation of the command:

  • :sort: you can prefix it with a range, like 1,3sort. Without a range, the whole buffer is used (i.e., %sort).
  • f: we are going to sort float numbers. We can also use x (hex number), b (binary number), o (octal number) etc.
  • /^.*,.*,/: the pattern we are going to skip during sort, i.e., content after the pattern will be sorted.

The default is to sort the lines in ascending order. To sort the lines in descending order, add a ! after :sort (i.e., use :sort!).

References

Author jdhao

LastMod 2021-12-21

License CC BY-NC-ND 4.0

Reward
Process video in a certain time range with ffmpeg?

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK