Extract row if both column values appear in a single column from a separate file

up vote
0
down vote

favorite

I have two tab-separated files:

File 1

123 456
135 567
234 478

File 2

123 notimportant notimportant2
456 notimportant notimportant2
987 notimportant notimportant2
135 notimportant notimportant2
234 notimportant notimportant2
478 notimportant notimportant2

I need to extract lines from file1 if both entries in a single row are present in file2's first column. So the output file should be like:

Output

123 456
234 478

I previously used this awk command to extract rows if only the first column of file1 matched 1st column of file2

awk 'FNR==NRa[$1];next($1 in a)print' file2 file1

But I don't know how to expand it.

edited Nov 17 at 0:37

Rui F Ribeiro

38.2k1475123

asked Mar 31 '17 at 9:41

Rūdolfs Bērziņš

add a comment |

up vote
0
down vote

favorite

I have two tab-separated files:

File 1

123 456
135 567
234 478

File 2

123 notimportant notimportant2
456 notimportant notimportant2
987 notimportant notimportant2
135 notimportant notimportant2
234 notimportant notimportant2
478 notimportant notimportant2

I need to extract lines from file1 if both entries in a single row are present in file2's first column. So the output file should be like:

Output

123 456
234 478

I previously used this awk command to extract rows if only the first column of file1 matched 1st column of file2

awk 'FNR==NRa[$1];next($1 in a)print' file2 file1

But I don't know how to expand it.

edited Nov 17 at 0:37

Rui F Ribeiro

38.2k1475123

asked Mar 31 '17 at 9:41

Rūdolfs Bērziņš

add a comment |

up vote
0
down vote

favorite

I have two tab-separated files:

File 1

123 456
135 567
234 478

File 2

123 notimportant notimportant2
456 notimportant notimportant2
987 notimportant notimportant2
135 notimportant notimportant2
234 notimportant notimportant2
478 notimportant notimportant2

I need to extract lines from file1 if both entries in a single row are present in file2's first column. So the output file should be like:

Output

123 456
234 478

I previously used this awk command to extract rows if only the first column of file1 matched 1st column of file2

awk 'FNR==NRa[$1];next($1 in a)print' file2 file1

But I don't know how to expand it.

edited Nov 17 at 0:37

Rui F Ribeiro

38.2k1475123

asked Mar 31 '17 at 9:41

Rūdolfs Bērziņš

I have two tab-separated files:

File 1

123 456
135 567
234 478

File 2

123 notimportant notimportant2
456 notimportant notimportant2
987 notimportant notimportant2
135 notimportant notimportant2
234 notimportant notimportant2
478 notimportant notimportant2

I need to extract lines from file1 if both entries in a single row are present in file2's first column. So the output file should be like:

Output

123 456
234 478

I previously used this awk command to extract rows if only the first column of file1 matched 1st column of file2

awk 'FNR==NRa[$1];next($1 in a)print' file2 file1

But I don't know how to expand it.

text-processing awk

edited Nov 17 at 0:37

Rui F Ribeiro

38.2k1475123

asked Mar 31 '17 at 9:41

Rūdolfs Bērziņš

edited Nov 17 at 0:37

Rui F Ribeiro

38.2k1475123

asked Mar 31 '17 at 9:41

Rūdolfs Bērziņš

edited Nov 17 at 0:37

Rui F Ribeiro

38.2k1475123

edited Nov 17 at 0:37

Rui F Ribeiro

38.2k1475123

edited Nov 17 at 0:37

Rui F Ribeiro

38.2k1475123

asked Mar 31 '17 at 9:41

Rūdolfs Bērziņš

asked Mar 31 '17 at 9:41

Rūdolfs Bērziņš

asked Mar 31 '17 at 9:41

Rūdolfs Bērziņš

add a comment |

1 Answer
1

active

oldest

votes

up vote
2
down vote

accepted

awk 'FNR==NRa[$1]++;next;($1 in a)&&($2 in a)print' file2 file1

perl -lane '
 @ARGV and $h$F[0]++,next;
 print if @F == grep $h$_ @F;
' file2 file1

edited Mar 31 '17 at 9:53

answered Mar 31 '17 at 9:48

user218374

add a comment |

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f355017%2fextract-row-if-both-column-values-appear-in-a-single-column-from-a-separate-file%23new-answer', 'question_page');

);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
2
down vote

accepted

awk 'FNR==NRa[$1]++;next;($1 in a)&&($2 in a)print' file2 file1

perl -lane '
 @ARGV and $h$F[0]++,next;
 print if @F == grep $h$_ @F;
' file2 file1

edited Mar 31 '17 at 9:53

answered Mar 31 '17 at 9:48

user218374

add a comment |

up vote
2
down vote

accepted

awk 'FNR==NRa[$1]++;next;($1 in a)&&($2 in a)print' file2 file1

perl -lane '
 @ARGV and $h$F[0]++,next;
 print if @F == grep $h$_ @F;
' file2 file1

edited Mar 31 '17 at 9:53

answered Mar 31 '17 at 9:48

user218374

add a comment |

up vote
2
down vote

accepted

awk 'FNR==NRa[$1]++;next;($1 in a)&&($2 in a)print' file2 file1

perl -lane '
 @ARGV and $h$F[0]++,next;
 print if @F == grep $h$_ @F;
' file2 file1

edited Mar 31 '17 at 9:53

answered Mar 31 '17 at 9:48

user218374

awk 'FNR==NRa[$1]++;next;($1 in a)&&($2 in a)print' file2 file1

perl -lane '
 @ARGV and $h$F[0]++,next;
 print if @F == grep $h$_ @F;
' file2 file1

edited Mar 31 '17 at 9:53

answered Mar 31 '17 at 9:48

user218374

edited Mar 31 '17 at 9:53

answered Mar 31 '17 at 9:48

user218374

answered Mar 31 '17 at 9:48

user218374

answered Mar 31 '17 at 9:48

user218374

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

搜尋此網誌

mjhjmtu