Shell Programming and Scripting

Hi all,

Here is a scim sample.bin.user file
a string1 0
a string2 0
a string3 63
b string4 126
c string5 315
d string6 0
e string7 63
e string8 126
f string9 0

I like to convert this into a dict.tab file to be compiled by the stardict-editor. The 3rd column (frequency) of the sample.bin.user is to be deleted, and the 1st column of each line must be unique, so here is what I like to achieve

a string1 string2 string3
b string4
c string5
d string6
e string7 string8
f string9

I spent a whole nice Friday evening but still couldn't figure out a neat solution.

Any pointer is most appreciated. Many thanks!

Code:

awk '{v=($1==x)?v FS $2:v RS $1 FS $2;x=$1}END{print v}' file

awk will work if the data's not too large.

Code:

# scim.awk
{
        if(a[$1])       a[$1]=a[$1] " " $2;
        else            a[$1]=$2;
}

END {   for(k in a) print k, a[k];      }

Code:

$ awk -f scim.awk < infile > outfile

It turns out that the tab file requires a tab between the two column so I edited a bit.

awk '{v=($1==x)?v FS $2:v RS $1"\t"$2;x=$1}END{print v}' in_file > out_file



Thanks to Corona688 too!

By the way anyone knows how to mark this thread as [SOLVED]?

I think you can edit your thread title if you edit your original post.