Re: compare values in the same field in consecutive rows--and store the result in an array
- From: Ed Morton <morton@xxxxxxxxxxxxxx>
- Date: Thu, 24 Jan 2008 13:41:45 -0600
On 1/24/2008 1:19 PM, z.entropic wrote:
<snip>
Here is a fragment of my input file:
============
100 24479.33 14399.09 1/23/2008 19:55 6 1 0 0 3.293 1.287
101 24480.25 14400.01 1/23/2008 19:55 6 1 0 0 3.296 1.288
102 24480.36 0.11 1/23/2008 19:55 7 1 0 -0.00185954 3.167 1.287
=============
Thus, if field $6 in line 100 is equal to 6 AND field $6 in line 101
is equal to 7, store the value 14399.09 in array1[1] and 1.287 in
array2[1]. When the next match is found, store the two values in
array1[2] and array2[2], etc. Basically, I'm comparing the same
fields in consecutive rows.
Try this:
awk '($6==7)&&(p6==6){array1[++n]=p3;array2[n]=p11} {p=$6;p3=$3;p11=$11}' file
You should use an array for the "p" (previous) field values if you to need to
access more of them.
Ed.
.
- Follow-Ups:
- References:
- compare values in the same field in consecutive rows--and store the result in an array
- From: z.entropic
- Re: compare values in the same field in consecutive rows--and store the result in an array
- From: Ed Morton
- Re: compare values in the same field in consecutive rows--and store the result in an array
- From: z.entropic
- compare values in the same field in consecutive rows--and store the result in an array
- Prev by Date: Re: compare values in the same field in consecutive rows--and store the result in an array
- Next by Date: Re: compare values in the same field in consecutive rows--and store the result in an array
- Previous by thread: Re: compare values in the same field in consecutive rows--and store the result in an array
- Next by thread: Re: compare values in the same field in consecutive rows--and store the result in an array
- Index(es):
Relevant Pages
|
