Hello everyone, i'm working on this project with a friend and we decided to split the project in half and i got the awk half (GREAT). so i have a list of states and people and i'm trying to write a command that will make end result look like this
California
Jenilee Harrison, San Francisco
Sam Karter, Los Angeles
Minnie Mouse, Anaheim
Florida
Gandalf Addison, Jupiter
Mickey Mouse, Orlando
Tawanda Rice, West Palm Beach
Adam Voter, Miami
Gollum Zeller, Tampa
Illinois
Zelda Bosco, Chicago
Milton Callahan, Schaumburg
Howard Messer, Orland Park
Ogden Nash, Berkeley
Penelope Ogden, Naperville
Indiana
Dominique Daniels, Gary
Susie Green, Indianapolis
Harvey Pelican, Michigan City
Byron Trapp, Indianapolis
Wisconsin
Vickie Edison, Milwaukee
Tom Furter, Milwaukee
Dave Ile, Madison
Waylon Jetson, Green Bay
Kendall Smith, Madison
I thought it would be fairly easy but i'm running into problems....this is what i have....
BEGIN { FS = "|" }
{ printf "%-40s %-20s %6.2f\n", $1, $2, $3, $4 }
but nothing happens
---------- Post updated at 06:59 PM ---------- Previous update was at 06:56 PM ----------
forgot to add what the files look like before
Florida:Mouse:Mickey:Orlando
California:Mouse:Minnie:Anaheim
Florida:Voter:Adam:Miami
Illinois:Bosco:Zelda:Chicago
Indiana:Green:Susie:Indianapolis
Wisconsin:Furter:Tom:Milwaukee
Wisconsin:Ile
ave:Madison
California:Karter:Sam:Los Angeles
Illinois:Messer:Howard:Orland Park
Illinois:Nash:Ogden:Berkeley
Illinois:Ogden:Penelope:Naperville
Indiana:Pelican:Harvey:Michigan City
Florida:Rice:Tawanda:West Palm Beach
Wisconsin:Smith:Kendall:Madison
Indiana:Trapp:Byron:Indianapolis
Illinois:Callahan:Milton:Schaumburg
Indiana
aniels
ominique:Gary
Wisconsin:Edison:Vickie:Milwaukee
Florida:Addison:Gandalf:Jupiter
Florida:Zeller:Gollum:Tampa
California:Harrison:Jenilee:San Francisco
Wisconsin:Jetson:Waylon:Green Bay