awk: find common data between two files

The name of the pictureThe name of the pictureThe name of the pictureClash 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.









share

























    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.









    share























      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.









      share













      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





      share












      share










      share



      share










      asked 6 mins ago









      Maddys

      33




      33

























          active

          oldest

          votes











          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%2f479834%2fawk-find-common-data-between-two-files%23new-answer', 'question_page');

          );

          Post as a guest



































          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















           

          draft saved


          draft discarded















































           


          draft saved


          draft discarded














          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













































































          Popular posts from this blog

          How to check contact read email or not when send email to Individual?

          Displaying single band from multi-band raster using QGIS

          How many registers does an x86_64 CPU actually have?