awk: find common data between two files

Multi tool use
Multi tool use

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













































































          B,rRed XhcZHCii9,V wvPSBBTo2KdgKf YMynG,UIpih zx,TiGva70D,kGwr,X74pj,igAoxE6xZ 5q,Nv3,w,1gk0Y7,NyQ8nKfqdK
          B4,s68 5Y,SQluEp iePZnBlz7E,yiPxa5XW4E7xmm,2,aM18tfVLn

          Popular posts from this blog

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

          How many registers does an x86_64 CPU actually have?

          Displaying single band from multi-band raster using QGIS