AWK - check column data - Page 3

tene · #15 01-02-2010

Code:

#!/usr/bin/awk

BEGIN {
   col3[""]=0;
   col4[""]=0;
}

{
   if(col3[$3] <= 0){
       col3[$3] = 1;
       data3 = $3;
   }
   else {
      col3[$3]++;
      data3 = ($3-0.1*(col3[$3]-1)); 
   }

   if(col4[$4] <= 0) {
      col4[$4] = 1;
      data4 = $4;
   }
   else {
      col4[$4]++;
      data4 = ($4-0.1*(col4[$4]-1));
   }

   print $1 $2 data3 data4;

}

aaiaz · #16 01-03-2010

another approach:-

Code:

nawk 'a[$3$4]++ { $3 -= 0.1}1' test

ahmad.diab · #17 01-03-2010

aaiaz:-

using multiplication and not && is for the subtraction value (amount) that we have to subtract after pattern repetition so you have to use
"*" not "&&"

by the way ...you code will not work proparly because each time you subtract
"0.1" although in the second pattern you have to subtract "0.2".

BR

aaiaz · #18 01-03-2010

Thanks man for the details ...I had understand now.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Extract data based on match against one column data from a long list data	patrick87	Shell Programming and Scripting	12	11-17-2009 03:27 AM
Linear data to column data..script help seeked	ak835	Shell Programming and Scripting	1	09-02-2009 01:32 PM
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 08:57 AM
check column	ust	Shell Programming and Scripting	1	01-24-2008 06:43 AM
How to check a column contain numeric or char data type ??	jambesh	Shell Programming and Scripting	12	10-06-2006 10:37 AM