
03-18-2009
|
|
Moderator(The Tutor)
|
|
|
Join Date: Jun 2008
Location: INDIA
Posts: 1,400
|
|
Quote:
Originally Posted by crazyhpux
by the way, the final file would be something like this:
abc1, defg, 000050.00, mno ,990, airplanes, runway,doctor
abc2, cats, 000100.00, pops ,991, jets,birds, much
abc3, dogs, 000001.00, treat,992, cars,ford, toyota
for number 3, I would assume use the join command?
|
your first file can be arranged in this way
Code:
awk -F, '{printf "%s,%s,%09.2f,%s,%s\n",$1,$2,$3,$4,$5}' filename
|