Search Results

awk '
!a[$1" "$2" "$3] || $4 > a[$1" "$2" "$3] { a[$1" "$2" "$3] = $4 }
END { for (i in a) print i, a[i] }
' INPUTFILE

Save the whole line, or the fields you want, when you save the maximum.


awk -F'\t' '
{
if( $6 > a[$1"\t"$4"\t"$5] )
{
a[$1"\t"$4"\t"$5] = $6
output[$1"\t"$4"\t"$5] = $0;...

awk -F "\t" '{a[$1 FS $2 FS $3]=(a[$1 FS $2 FS $3]>$NF)?a[$1 FS $2 FS $3]:$NF}
END {for (i in a) print i FS a[i]}' urfile

bash
#!/bin/bash
IFS=" " # is a Tab
sort -r infile | while read A B C D
do [ "$L" != "$A$B$C" ] && { L=$A$B$C; echo -e "$A\t$B\t$C\t$D"; }
done

if you need a sorted output
#!/bin/bash...

Hi,

try:

awk '{if ($4 > a[$1" "$2" "$3])a[$1" "$2" "$3]=$4}END{for (i in a) print i, a[i]}' file

Output:

3333 4444 BBBB 0.7
1111 2222 AAAA 0.9


HTH Chris

awk '{a[$0]++}END{for (i in a) print i, a[i]}' urfile

find . -type f -name "*.doc" | while read fn; do
mv -v "$fn" "$(echo $fn | sed 's/\.doc$/\.txt/')"
done

Another way is to read the file twice:
awk 'NR==FNR{a[$1]++;next} a[$1]>=min' min=3 file file

awk 'END {
for (i = 0; ++i <= NR;)
if (count[pos[i]] >= min)
print pos[i]
}
{
pos[NR] = $0; count[$0]++
}' min=3 infile

If your awk implementation has no access to NR...

awk '{a[$0]++}END{for (i in a) if (a[i]>=3) for (j=1;j<=a[i];j++) print i}' file

Fix for Guru's code: awk 'NR==FNR{a[$1" "$2]=$3;next;}length(a[$1" "$2])>0{ if (a[$1" "$2] > $3) print $1, $2,a[$1" "$2]; else print;}' file1 file2

Oops...


awk 'NR==FNR{a[$1" "$2]=$3;next;}($1" "$2 in a){if(a[$1" "$2] > $3) print $1, $2,a[$1" "$2]; else print;}' file1 file2


Guru.

Hi

awk '{a[$1]++; j++}END{ for (i in a) print a[i],i,j;}' infile

Guru.

As an example:


ls A | while read FILE; do
cat A/"$FILE" B/"$FILE" >> C/"$FILE"
done

to append the A and B files to new files (with the same names) somewhere else.

One way, assuming A and B directories are in the current directory, and that A and B contain only files:


ls A | sed "s|.*|cat A/& >> B/&|" | sh



$ ls A
1.txt 2.txt 3.txt

$ cat A/1.txt...