Need some help with the UNIXlinux sed command Consider the f

Need some help with the UNIX/linux sed command:

Consider the file addr below:

$ cat addr

Xiao Li, lxiao@unc.edu, 6705462234, Jackson, NC 764
Elizi Moe, emoe@ncsu.edu, 5208534566, Tempe, AZ 85282
Ma Ta, mta@yahoo.com, 4345667345, Austin, TX 91030
Diana Cheng, dcheng@asu.edu, 5203456789, Matitsi, WY 4587
Jackson Five, jfive@ncsu.edu, 5206564573, Kyenta, AZ 85483
Adi Srikanth Reddy, sadi1@imap1.asu.edu, 6578904566, Wyo, WS 67854 Natkin William, wnatkin@imap28.asu.edu, 8044344528, Richmond, VA 22345

1.Write a sed script called activity61 to format the above file as: FullNname PhoneNumber EmailAddress

Note that the required format is tab-separated

The required format must also be sorted by names Lines with private email addresses must be deleted

Provide the command to run your script

(Please show the steps and commands to do this, thanks.)

Solution

First thing
Creat a file
Example :-

$vi sample.txt
In sample.txt paste all your data and tyoe :wq and save the data.
Now create a sample script to catch up the rewuirement.

$vi activity61.sh

and we will be redirected to a place where we need to develop our script.

activity61.sh :-
#!/bin/bash
cd #path

sed \'s/\\(\\([^;]*;\\)\\{2\\}\\)\\(.*\\)/\\1\\2\\1/ ; s/;$// ; s/\\(.*\\);/\\1-/\' sample.txt