CODEWITHSUNDEEP
sqlvimeditorvi
Damon Snyder
Damon Snyder

Reputation: 1372

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

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.

Upvotes: 7

Views: 3921

Answers (3)

zah
zah

Reputation: 5384

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

Upvotes: 1

Brad Cox
Brad Cox

Reputation: 384

Try

:r | YourCommand

For example:

:r ! echo foo

adds foo to your buffer.

Upvotes: 0

mweerden
mweerden

Reputation: 14051

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.

Upvotes: 7

Related Questions