calculate from three files - Shell Programming and Scripting - The UNIX and Linux Forums

The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
calculate from three files

.

google unix.com

Mark Forums Read

Thread: calculate from three files

View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->

#3 (permalink)

Old

01-08-2008

dennis.jacob dennis.jacob is offline

dennis.jacob is offline

Forum Advisor

dj - the student

Join Date: Feb 2007

Location: Singapore/Bangalore/Cochin

Posts: 603

Code:

paste file1 file2 file3 |sed 's/|/ /g'|awk '{ if ($6=="") $6=0;if ($4=="") $4=0; if ($2=="") $2=0;print $1 "|" $2 "|" $4 "|" $6"|"$2+$4-$6;}'

Output:

Quote:

1|100|200|300|0
2|200|200|100|300
3|300|600|200|700
4|400|800|0|1200
5|500|0|0|500