Search Results

Thank you!

For others who might run into a similar problem I gathered some more options:

Perl solution:
$ perl -lane 'BEGIN{open(A,"file1"); while(<A>){chomp; @F=split(/\t/); ...

Thanks, your answer worked on my example. However, the real files I deal with have reocurrence of specified identifiers from column 1, eg.

File 1:
1 today
1 green
2 tomorrow
3 red
1 today ...

I would like to merge two tables based on column 1:

File 1:

1 today
1 green
2 tomorrow
3 red

File 2:

1 a lot
1 sometimes
2 at work
2...