UNIX for Dummies Questions & Answers

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:

Code:

orderdetail.ccntyfips
orderdetail.citemord
orderdetail.coffdetid

I want to go to this:

Code:

COUNT(DISTINCT(orderdetail.ccntyfips)) as ccntyfips,
COUNT(DISTINCT(orderdetail.citemord)) as citemord,
COUNT(DISTINCT(orderdetail.coffdetid)) as coffdetid,

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:

Code:

:%s/[tablename].[fieldname]/COUNT(DISTINCT([tablename].[fieldname])) as [fieldname],/g

If this is possible what would the proper syntax be?

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

Code:

%s/orderdetail\.\(.*\)/COUNT(DISTINCT(orderdetail.\1)) as \1,/g

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.

Code:

{!}awk -F'.' '{print "COUNT(DISTINCT(" $0 ")) as " $2 ","}'