Search Results

Try:

awk -v n=6 '
function fill() {
while (++i<=n)
print p,0
i=0
}
$1!=p && NR>1 {
fill()
}
{
++i
p=$1
print
}
END{
fill()
}
'...

$
$
$ cat data.txt
3386(11:11,Ani:0,Bri:1,ch:1,Jwe:0,Jor:0,LP:0,Lo:0,NS:1,al:1,bo:0,boy:0,bru:0,sh:0,cor:1,dum:0,ery:0,mac:0,mic:0)...

something along these lines: awk -f kanja.awk myFile where kanja.awk is:

BEGIN {
FS="[():,]"
OFS="\t"
}
{
idL=(!idL)?$1:idL OFS $1
for(i=4;i<=NF-1;i=i+2) {
if (FNR==1)...

If you don't mind having the same format in output lines as you have in the input file, and none of fields 6 through 9 ever have negative values, the easy way to do what you requested would be:
awk...

awk ' {LN[$1]; HD[$2]; MX[$1,$2]=1}
END { printf "%10s", ""; for (i in HD) printf "%10s", i; print "";
for (j in LN) {printf "%10s",j; for (i...

Another awk approach:
awk '
NR == FNR {
A[++c] = $1 OFS $2 OFS $3
next
}
{
for ( i = 1; i <= c; i++ )
{...

I assumed that comma is separator use this

%s/\<A1\>/test/g:%s/\<A1\>\C/test/g -----> case sensitive

I guess this is what you want:awk '{max=""; for (i=4; i<=NF; i++) if ($i>max) max=$i; print $0, max/$3}' file
1 r 109 45 3 5 6 7 0.412844
2 f 300 249 5 8 10 0.83
3 g 120 4 5 110 0 0.916667
4 t...