Search Results

You can simply use an if statement to test if the value is above or below the threshold and set the field to 1 or 0 based on that.

awk '{$2=($2<n)?0:1}1'

where n is the desired threshold (e.g....

With a recent bash that provides "process substitution", try
join <(join file[12]) <(join file[34])

read the man pages for the cut and paste commands.

---------- Post updated at 10:05 AM ---------- Previous update was at 10:01 AM ----------



use the cut command to retrieve only the second...

The "if?then:else" is a "value if", a ternary operator.
Here with another ternary operator in the "else".

In your explicit if-then-else clause it must be
else if ($3 == $2) because $3 = $2 is an...

So you've done it on your own! Congrats!

Next time you might consider
awk '{print $1, ($2>$3)?0:($2<$3)?1:2}' file3
label1 0
label2 0
label3 1
label4 2
label5 1
label6 0 as well.

Mayhap another if ... then ... construct?

Thanks to the example things are clear now.
#!/bin/sh
awk '
function maxcol(startcol,endcol){
_maxcol=$startcol
while (++startcol<=endcol) {
if ($startcol>_maxcol)...