compare first column of 2 file : while second have 2 column but first have one column [duplicate]

up vote
1
down vote

favorite

This question is an exact duplicate of:

If column matches another file, print every line with match (awk/grep)

3 answers

i have 2 file :

file 1:

abc
mno
pqd

file 2:

ump 10
abc 12
sfg 30
klp 45
mno 21
pqd 32
jkl 98
lkg 45

I want output like this:

abc 12
mno 21
pqd 32

edited Jul 11 at 11:45

SivaPrasath

3,68311636

asked Jul 11 at 11:44

Saurabh Shukla

marked as duplicate by steeldriver, schily, Jeff Schaller, slmâ™¦ Jul 11 at 13:28

This question was marked as an exact duplicate of an existing question.

add a commentÂ |Â

up vote
1
down vote

favorite

This question is an exact duplicate of:

If column matches another file, print every line with match (awk/grep)

3 answers

i have 2 file :

file 1:

abc
mno
pqd

file 2:

ump 10
abc 12
sfg 30
klp 45
mno 21
pqd 32
jkl 98
lkg 45

I want output like this:

abc 12
mno 21
pqd 32

edited Jul 11 at 11:45

SivaPrasath

3,68311636

asked Jul 11 at 11:44

Saurabh Shukla

marked as duplicate by steeldriver, schily, Jeff Schaller, slmâ™¦ Jul 11 at 13:28

This question was marked as an exact duplicate of an existing question.

add a commentÂ |Â

up vote
1
down vote

favorite

This question is an exact duplicate of:

If column matches another file, print every line with match (awk/grep)

3 answers

i have 2 file :

file 1:

abc
mno
pqd

file 2:

ump 10
abc 12
sfg 30
klp 45
mno 21
pqd 32
jkl 98
lkg 45

I want output like this:

abc 12
mno 21
pqd 32

edited Jul 11 at 11:45

SivaPrasath

3,68311636

asked Jul 11 at 11:44

Saurabh Shukla

This question is an exact duplicate of:

If column matches another file, print every line with match (awk/grep)

3 answers

i have 2 file :

file 1:

abc
mno
pqd

file 2:

ump 10
abc 12
sfg 30
klp 45
mno 21
pqd 32
jkl 98
lkg 45

I want output like this:

abc 12
mno 21
pqd 32

This question is an exact duplicate of:

If column matches another file, print every line with match (awk/grep)

3 answers

edited Jul 11 at 11:45

SivaPrasath

3,68311636

asked Jul 11 at 11:44

Saurabh Shukla

edited Jul 11 at 11:45

SivaPrasath

3,68311636

edited Jul 11 at 11:45

SivaPrasath

3,68311636

edited Jul 11 at 11:45

SivaPrasath

3,68311636

asked Jul 11 at 11:44

Saurabh Shukla

asked Jul 11 at 11:44

Saurabh Shukla

asked Jul 11 at 11:44

Saurabh Shukla

marked as duplicate by steeldriver, schily, Jeff Schaller, slmâ™¦ Jul 11 at 13:28

This question was marked as an exact duplicate of an existing question.

marked as duplicate by steeldriver, schily, Jeff Schaller, slmâ™¦ Jul 11 at 13:28

This question was marked as an exact duplicate of an existing question.

add a commentÂ |Â

1 Answer
1

active

oldest

votes

up vote
10
down vote

accepted

Try join :

# join <(sort file1) <(sort file2)
abc 12
mno 21
pqd 32

edited Jul 11 at 12:21

answered Jul 11 at 11:48

SivaPrasath

3,68311636

add a commentÂ |Â

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
10
down vote

accepted

Try join :

# join <(sort file1) <(sort file2)
abc 12
mno 21
pqd 32

edited Jul 11 at 12:21

answered Jul 11 at 11:48

SivaPrasath

3,68311636

add a commentÂ |Â

up vote
10
down vote

accepted

Try join :

# join <(sort file1) <(sort file2)
abc 12
mno 21
pqd 32

edited Jul 11 at 12:21

answered Jul 11 at 11:48

SivaPrasath

3,68311636

add a commentÂ |Â

up vote
10
down vote

accepted

Try join :

# join <(sort file1) <(sort file2)
abc 12
mno 21
pqd 32

edited Jul 11 at 12:21

answered Jul 11 at 11:48

SivaPrasath

3,68311636

Try join :

# join <(sort file1) <(sort file2)
abc 12
mno 21
pqd 32

edited Jul 11 at 12:21

answered Jul 11 at 11:48

SivaPrasath

3,68311636

edited Jul 11 at 12:21

answered Jul 11 at 11:48

SivaPrasath

3,68311636

answered Jul 11 at 11:48

SivaPrasath

3,68311636

answered Jul 11 at 11:48

SivaPrasath

3,68311636

add a commentÂ |Â

搜尋此網誌

mjhjmtu