awk: find common data between two files
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
File 1 (Master Data):
12345|abc
11223|xyz
23234|pqr
File 2 (Sub set of File1):
12345_ASDD|PASD|AWOP
11223_PLDD|EVAAA ASDAS|ASDD
23234_MJKJLO|OKEI JSN|OPIE
Output:
12345_ASDD|PASD|AWOP|abc
11223_PLDD|EVAAA ASDAS|ASDD|xyz
23234_MJKJLO|OKEI JSN|OPIE|pqr
Explanation:
First column (before underscore) of File2 should match with first column of File1 and corresponding second column of File1 should be added to File2.
shell-script awk
add a comment |Â
up vote
0
down vote
favorite
File 1 (Master Data):
12345|abc
11223|xyz
23234|pqr
File 2 (Sub set of File1):
12345_ASDD|PASD|AWOP
11223_PLDD|EVAAA ASDAS|ASDD
23234_MJKJLO|OKEI JSN|OPIE
Output:
12345_ASDD|PASD|AWOP|abc
11223_PLDD|EVAAA ASDAS|ASDD|xyz
23234_MJKJLO|OKEI JSN|OPIE|pqr
Explanation:
First column (before underscore) of File2 should match with first column of File1 and corresponding second column of File1 should be added to File2.
shell-script awk
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
File 1 (Master Data):
12345|abc
11223|xyz
23234|pqr
File 2 (Sub set of File1):
12345_ASDD|PASD|AWOP
11223_PLDD|EVAAA ASDAS|ASDD
23234_MJKJLO|OKEI JSN|OPIE
Output:
12345_ASDD|PASD|AWOP|abc
11223_PLDD|EVAAA ASDAS|ASDD|xyz
23234_MJKJLO|OKEI JSN|OPIE|pqr
Explanation:
First column (before underscore) of File2 should match with first column of File1 and corresponding second column of File1 should be added to File2.
shell-script awk
File 1 (Master Data):
12345|abc
11223|xyz
23234|pqr
File 2 (Sub set of File1):
12345_ASDD|PASD|AWOP
11223_PLDD|EVAAA ASDAS|ASDD
23234_MJKJLO|OKEI JSN|OPIE
Output:
12345_ASDD|PASD|AWOP|abc
11223_PLDD|EVAAA ASDAS|ASDD|xyz
23234_MJKJLO|OKEI JSN|OPIE|pqr
Explanation:
First column (before underscore) of File2 should match with first column of File1 and corresponding second column of File1 should be added to File2.
shell-script awk
shell-script awk
asked 6 mins ago
Maddys
33
33
add a comment |Â
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f479834%2fawk-find-common-data-between-two-files%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