Shell Programming and Scripting

Name                  Email                                    Location         Phone
Tom Smith          toms@me.com                     home              +65 5555 5555
John,,,
Jerry T. Wright   jerry@me.com                      NY office       +1 212 555 5555
Phil Dell             phil@me.com                                              +1 212 555 1111

Name,Email,Location,Phone
Tom Smith,toms@me.com,home,+65 5555 5555
John,,,
Jerry T. Wright,jerry@me.com,NY office,+1 212 555 5555
Phil Dell,phil@me.com,,+1 212 555 1111

sed -e 's/[ ]*\([a-z0-9_-.]*@[a-z0-9_-.]*\)[ ]*/,\1,/g;
s/[ ]*\([0-9 ]+\)/,\1/;
s/[ ]*Email[ ]*/,Email,/;
s/Location[ ]*Phone/Location,Phone/;s/[ ]*+/+/'  inputfile > outputfile

sed -e 's/[\+][0-9 ]*/,&,/' -e 's/[a-z0-9_-.]*@[a-z0-9_-.]*/,&,/' inputfile

Name,Email,Location,Phone
Tom Smith,toms@me.com,home,+65 5555 5555
John
Jerry T. Wright,jerry@me.com,NY office,+1 212 555 5555
Phil Dell,phil@me.com,+1 212 555 1111

sed -e 's/[ ]*\([a-z0-9_-.]*@[a-z0-9_-.]*\)[ ]*/,\1,/g;
s/[ ]*\([0-9 ]+\)/,\1/;
s/[ ]*Email[ ]*/,Email,/;
s/Location[ ]*Phone/Location,Phone/;s/[ ]*+/+/;
s/\(@.*\.[a-z]\{3,4\},\)+/\1,+/;
s/\([a-zA-Z .]$\)/\1,,,/;s/,Phone,,,/,Phone/' inputfile