Search Results

Try awk ' {F2[$1]=F2[$1]"/"$2
F3[$1]=F3[$1]"/"$3
F4[$1]=F4[$1]";"$4}
END {for (S1 in F2)
print S1,
...

awk based solution

$ cat test.sh
awk '
{
if (NR == FNR) ### reading 1st file
### accumulate 2nd column values in array of key values
{
...

Nice one Akshay.

I made a modification to allow sorting within the awk statement:


awk '{A[$1]=A[$1] ? A[$1] OFS $2 : $2}END{for(i in A)print i, A[i] | "sort"}' file*
rs0001 100e-34 1.98e-22...

Try

$ awk '{A[$1] = A[$1] ? A[$1] OFS $2 : $2}END{for(i in A)print i, A[i]}' file* | sort--edit--

Oops looks like desired o/p modified :)
$ awk 'BEGIN{printf "\t"}{A[$1] = A[$1] ? A[$1] OFS...