Shell Programming and Scripting

I am working with a file of the form;

4256 7726 1
6525 716 1
7626 0838 1
8726 7623 2
8625 1563 2
1662 2628 3
1551 3552 3
1542 7984 3
1615 5145 3

I want to convert it so that everytime the separator in the 3rd column changes, it inserts a row with follwing data;

1.00000E+030 1.00000E+00 1.00000E+030

so finally the file should look like

4256 7726 1
6525 1680 1
7626 0838 1
1.00000E+030 1.00000E+00 1.00000E+030
8726 8782 2
8625 1563 2
1.00000E+030 1.00000E+00 1.00000E+030
1662 2628 3
1551 3552 3
1542 7984 3
1615 5145 3

I will appreciate any help on this issue.

This should work for you

Code:

awk '{$0=(_&&_!=$NF)?x RS$0:$0;_=$NF}1END{print x}' x="1.00000E+030 1.00000E+00 1.00000E+030" file

Use gawk, nawk or /usr/xpg4/bin/awk on Solaris.

---------- Post updated at 06:03 AM ---------- Previous update was at 06:03 AM ----------

To keep the forums high quality for all users, please take the time to format your posts correctly.
Thank You.

The UNIX and Linux Forums
Reply With Quote

Another way :

Code:

awk ' NR > 1 { if($3!=f){print "1.00000E+030 1.00000E+00 1.00000E+030" ; print ;f=$3 ;next } }{ f=$3; print ;next } END{print "1.00000E+030 1.00000E+00 1.00000E+030" }'  File_name.txt

Code:

awk '{if(tmp=="")
          tmp=$3
      if($3!=tmp)
      {
          print "1.00000E+030 1.00000E+00 1.00000E+030"
          tmp=$3
      }
      print $0
}'