Full name

dyiwu included in tech

2019-05-31 202 words One minute

Contents

This awk script translates the format of full name list in input file from the first name first format to the last name first format.

Here is the awk code.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23


$ cat fullname.awk
#!/usr/bin/awk -f
{
  OFS="";
  $1=$1;
  $2=$2;
  $3=$3;
#  print "---",$1,"---,"$2,"---,"$3"---";
  if ($1 == "" && $2 == "" && $3 == "") print ;
  else
  {
  FirstName=$1;
  if ($3 != "")
    { MiddleName=$2;
      LastName=$3;
      print LastName,", ",FirstName," ",MiddleName;
      }
  else
    { LastName=$2;
      print LastName,", ",FirstName;
      }
  }
}

Run time example,

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26


$ nl -b a namelist.txt
     1  Prest Lin
     2  Cereal Mak
     3  Joo kim Chong
     4
     5
     6  David Wu
     7  Poh Leng Lim
     8
     9  Vincent Ng
    10  Johnson Hsiao 
$
$ ./fullname.awk namelist.txt > out.txt
$
$ nl -b a out.txt
     1  Lin, Prest
     2  Mak, Cereal
     3  Chong, Joo kim
     4
     5
     6  Wu, David
     7  Lim, Poh Leng
     8
     9  Ng, Vincent
    10  Hsiao, Johnson