Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Subtracting columns using awk

Comment:

How do I subtract column #2 in one file from column #2 in another file and then print column #1 and the result of the subtraction into a third file? Thanks a lot!

Reply:

Try the below, redirecting the output to a third file: file1 AA 10 AA 10 AA 10 File2 BB 50 BB 40 BB 30 $ nawk 'FNR==NR {arr[NR]=$2; next} { print $2-arr[FNR]}' file1 file2 40 30 20

0

Reply:

Should work for whichever flavor of awk you use; gawk -F'field separator eg space' '{print $2 - $1}' filename > newfile

0

sed script

sed: conditional newline ...

Summary: I would like to subtract a single value to a file using awk. It has been quite difficult to figure out how ? What I wanted to do is : I have a file that contains a column : 1 2 3 4 5 6. I want to subt...

Summary: I've a loop to read a file line by line. Now each line has 4 columns seperated by space. How do I get 4 diff column values using awk to 4 seperate variables? eg of a line: adas 343434 adas@adas.org I...

Summary: I've a loop to read a file line by line. Now each line has 4 columns seperated by space. How do I get 4 diff column values using awk to 4 seperate variables? eg of a line: adas 343434 adas@adas.org I...