subset a large file based on elements in another file
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
I would like to subset a large file based on elements in another file in bash. Here is an example data for the first file:
Col1,Col2,Col3
A,10,50
B,10,05
C,20,30
B,20,03
A,30,100
C,30,111
D,40,120
The second file is:
A
B
C
I would to save subset of file1 with first column takes value "A" to A.txt; and "B" to B.txt, and so on.
Before I am using
awk '$1=="A"' file1.txt > A.txt
but now I have to deal with 100+ different names in the second file, looking for a better way to get the job done. Thanks!!!
text-processing awk command-line
New contributor
add a comment |Â
up vote
0
down vote
favorite
I would like to subset a large file based on elements in another file in bash. Here is an example data for the first file:
Col1,Col2,Col3
A,10,50
B,10,05
C,20,30
B,20,03
A,30,100
C,30,111
D,40,120
The second file is:
A
B
C
I would to save subset of file1 with first column takes value "A" to A.txt; and "B" to B.txt, and so on.
Before I am using
awk '$1=="A"' file1.txt > A.txt
but now I have to deal with 100+ different names in the second file, looking for a better way to get the job done. Thanks!!!
text-processing awk command-line
New contributor
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I would like to subset a large file based on elements in another file in bash. Here is an example data for the first file:
Col1,Col2,Col3
A,10,50
B,10,05
C,20,30
B,20,03
A,30,100
C,30,111
D,40,120
The second file is:
A
B
C
I would to save subset of file1 with first column takes value "A" to A.txt; and "B" to B.txt, and so on.
Before I am using
awk '$1=="A"' file1.txt > A.txt
but now I have to deal with 100+ different names in the second file, looking for a better way to get the job done. Thanks!!!
text-processing awk command-line
New contributor
I would like to subset a large file based on elements in another file in bash. Here is an example data for the first file:
Col1,Col2,Col3
A,10,50
B,10,05
C,20,30
B,20,03
A,30,100
C,30,111
D,40,120
The second file is:
A
B
C
I would to save subset of file1 with first column takes value "A" to A.txt; and "B" to B.txt, and so on.
Before I am using
awk '$1=="A"' file1.txt > A.txt
but now I have to deal with 100+ different names in the second file, looking for a better way to get the job done. Thanks!!!
text-processing awk command-line
text-processing awk command-line
New contributor
New contributor
New contributor
asked 3 mins ago
mathcz
1
1
New contributor
New contributor
add a comment |Â
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
mathcz is a new contributor. Be nice, and check out our Code of Conduct.
mathcz is a new contributor. Be nice, and check out our Code of Conduct.
mathcz is a new contributor. Be nice, and check out our Code of Conduct.
mathcz is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f478177%2fsubset-a-large-file-based-on-elements-in-another-file%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password