How to pipe visually selected text to a UNIX command and append output to current buffer in Vim

Question

Using Vim, I'm trying to pipe text selected in visual mode to a UNIX command and have the output appended to the end of the current file. For example, say we have a SQL command such as:

SELECT * FROM mytable;

I want to do something like the following:

<ESC>
V                 " select text
:'<,'>!mysql -uuser -ppass mydb

But instead of having the output overwrite the currently selected text, I would like to have the output appended to the end of the file. You probably see where this is going. I'm working on using Vim as a simple SQL editor. That way, I don't have to leave Vim to edit, tweak, test SQL code.

Thanks! That worked as expected. Here is the actual command I used: com -range C <line1>,<line2>yank | $ | put | .,$ !/usr/local/mysql/bin/mysql -uuser mydb I had a "select * from table;" line in the text file and I just <ESC>:C and it dumped the output at the end of the file. — Damon Snyder
– Damon Snyder, Commented Oct 23, 2008 at 17:42

mweerden · Accepted Answer · 2008-10-23 16:51:51Z

7

How about copying the selected text to the end of the file, select the copy and run the command? If you do not want to repeat the same commands over and over again, you can record the sequence by using q or add a new command. I have tried the latter as follows:

:com -range C <line1>,<line2>yank | $ | put | .,$ !rev

With it you can select some lines and then type :C. This will first yank the selection, then go to the end of the file, paste the yanked text and run the command (rev in this case) over the new text.

answered Oct 23, 2008 at 16:51

mweerden

14.1k5 gold badges35 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zah · Accepted Answer · 2012-09-13 22:42:16Z

1

If you prefer more programmatic approach, you can have

:call append(line("$"), system("command", GetSelectedText()))

where GetSelectedText is the reusable function:

func! GetSelectedText()
  normal gv"xy
  let result = getreg("x")
  normal gv
  return result
endfunc

answered Sep 13, 2012 at 22:42

zah

5,3741 gold badge37 silver badges31 bronze badges

Comments

Keith Pinson · Accepted Answer · 2012-09-13 18:22:25Z

0

Try

:r | YourCommand

For example:

:r ! echo foo

adds foo to your buffer.

edited Sep 13, 2012 at 18:22

Keith Pinson

8,0339 gold badges64 silver badges113 bronze badges

answered Feb 8, 2011 at 15:02

Brad Cox

3842 silver badges6 bronze badges

Collectives™ on Stack Overflow

How to pipe visually selected text to a UNIX command and append output to current buffer in Vim

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related