I use vim. I have a lot of SQL queries to write, and am hoping there is some wild command I can use in vim to make this simpler.

From a file that is a list of fields, like the excerpt, for example:

I want to go to this:

I'm not sure if such a thing can be done with one line of command. Fortunately, all lines will be in the same format.. tablename.fieldname. so I know that I need to do something like:

If this is possible what would the proper syntax be?

__________________
[url=http://www.glitterchildren.com/phpBB2]GlitterChildren Forums[/url]

for anybody with a similiar problem.. i received the issue on another forum:

__________________
[url=http://www.glitterchildren.com/phpBB2]GlitterChildren Forums[/url]

Although the solution is found, it's worth mentioning that you can also pipe a file through a command using {!} from within vi, e.g.