Shell Programming and Scripting

Dear All,

I am having a file with thousands of columns. I would like to find the difference between adjacent columns (ie $i and $(i+1)) and perform the following action:

if the difference is less than -10, then i need to print "-2";
if the difference is between 0 and <-9, then i need to print "-1";
if the difference is between 0 and < 9, then i need to print "1"; and
if the difference is more than 10, then i need to print "2".

for this i have tried the following code, but its now working and giving me the syntax error at else position. Here is the code

Code:

awk '{for(i=1; i<NF; i++) {if(($i-$(i+1)) < -10); printf "-2 "; elsif(($i-$(i+1)) > -10 && ($i-$(i+1)) <0); printf "-1 "; elsif(($i-$(i+1))>0 && ($i-$(i+1))<10); printf "1 "; else printf "2 "}} {print "\n"}' inputfile > outputfile

Can anyone help me to sort out this problem?

Expecting your reply and thanks in advance.

Regards
Fredrick.

---------- Post updated at 03:23 PM ---------- Previous update was at 02:35 PM ----------

Sorry, there was a typo error. It should be like this:

It was not working and giving me syntax error.

regards
Fredrick.

Maybe try this (I don't think elsif works in awk):

Code:

awk '{for(i=1; i<NF; i++) {if(($i-$(i+1)) < -10) {printf "-2 "} else if(($i-$(i+1)) > -10 && ($i-$(i+1)) <0) {printf "-1 "} else if(($i-$(i+1))>0 && ($i-$(i+1))<10) {printf "1 "} else {printf "2 "}}} {print "\n"}' inputfile > outputfile

Thank you very much for your reply cmf1985. Its working fine.

Warm regards
Fredrick.