UNIX for Dummies Questions & Answers

Hi.


If we have this file

A B C
7 8 9
1 2 10


and this other file

A C D F
7 9 2 3
9 2 3 4

The result i´m looking for is intersection with A B C D F

so the answer here will be

7 8 9 2 3

So how do we do a intersection using to compare just the column 1 .


I think what I want is very similiar to this topic, but didn´t work for me

https://www.unix.com/unix-dummies-que...two-files.html

I´m lost for my next step.
I´m using solaris 10

Thanks very much.

Hmm.... I don't quite understand the logic how you determine the 'intersection'...
What does that mean:
Can you try explaining again, please.

What does 'just the column 1' mean? If column 1 is a small number your intersection will be large.

This is a start, using only column 1 to compare, giving a union:

Code:

awk ' FILENAME=="file1" { one[$1]=one[$1] $0}
        FILENAME=="file2" { two[$1]=two[$1] $0}
        END { for (i in one) { if (i in two) {print one[i], two[i]} }  }

If this is really what you want we can go on to creating "unique" output - an intersection.

Looks like vgersh99 and I are equally confused...

Sorry, I will try to explain more detailed


the intersection is all lines that have the numbers in the column A equal.

I will compare lines from set1 to set2, but just using the members of column A.

something like this

FOR each lines OF set1
FOR each line of set2
if first member of this line (columnA) of set1 == first member of the line of setB
print line set1 + of setB
end IF
end FOR
end FOR


So if I have
set1
columns A B C
first line 7 9 10
second line 8 10 12


set2
columns A D E
first line 6 9 10
second line 8 13 12


I will compare all lines of this two sets and look for lines that have the equal A, when I find the equal A, print this line of set1 + set2.


It is better now? Sorry for the english, it is my second language.

That is what the awk code I wrote for you does. Try it. The code assumes the A B C header you wrote is not in the file.

I´m getting error.
awk: syntax error near line 1
awk: bailing out near line 1


here is a example of things that have inside my files.
set1
pts/86 3:14 angelinajolie
pts/93 1:05 jessicaalba
pts/96 1:12 danielelima

set2

pts/90 3499 panda
pts/92 2301 jimcarey
pts/93 4313 jessicalba
pts/94 23878 brasil
pts/95 5186 ferrari
pts/97 19685 porshe


the answer I desire is
pts/93 1:05 jessicaalba 4313 ( no problem if repeat column)


and OMG, the idea is simple but is so hard to explain in english