I want to compare two files and get the difference in new file with the changed column number for each row












0















I want to compare two files and get the difference in new file with the changed column number for each row. Both the files have same structure with sorted data and same number of rows.



I have two files,



File 1



01|Akshaya|9657|Pune
02|Samiksha|8391|Mumbai


File 2



01|Akshaya|9657|Nashik
02|Samiksha|0202|Nagpur


I want to compare these two files and need output like below in new file.



File 3



Sr no|Col no
01|3
02|2,3


Can someone please help me on this ???










share|improve this question









New contributor




Akshhayah Mahurkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    I want to compare two files and get the difference in new file with the changed column number for each row. Both the files have same structure with sorted data and same number of rows.



    I have two files,



    File 1



    01|Akshaya|9657|Pune
    02|Samiksha|8391|Mumbai


    File 2



    01|Akshaya|9657|Nashik
    02|Samiksha|0202|Nagpur


    I want to compare these two files and need output like below in new file.



    File 3



    Sr no|Col no
    01|3
    02|2,3


    Can someone please help me on this ???










    share|improve this question









    New contributor




    Akshhayah Mahurkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I want to compare two files and get the difference in new file with the changed column number for each row. Both the files have same structure with sorted data and same number of rows.



      I have two files,



      File 1



      01|Akshaya|9657|Pune
      02|Samiksha|8391|Mumbai


      File 2



      01|Akshaya|9657|Nashik
      02|Samiksha|0202|Nagpur


      I want to compare these two files and need output like below in new file.



      File 3



      Sr no|Col no
      01|3
      02|2,3


      Can someone please help me on this ???










      share|improve this question









      New contributor




      Akshhayah Mahurkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I want to compare two files and get the difference in new file with the changed column number for each row. Both the files have same structure with sorted data and same number of rows.



      I have two files,



      File 1



      01|Akshaya|9657|Pune
      02|Samiksha|8391|Mumbai


      File 2



      01|Akshaya|9657|Nashik
      02|Samiksha|0202|Nagpur


      I want to compare these two files and need output like below in new file.



      File 3



      Sr no|Col no
      01|3
      02|2,3


      Can someone please help me on this ???







      shell-script shell






      share|improve this question









      New contributor




      Akshhayah Mahurkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      Akshhayah Mahurkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited 14 mins ago









      Archemar

      20.1k93772




      20.1k93772






      New contributor




      Akshhayah Mahurkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 15 mins ago









      Akshhayah MahurkarAkshhayah Mahurkar

      1




      1




      New contributor




      Akshhayah Mahurkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Akshhayah Mahurkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Akshhayah Mahurkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          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',
          autoActivateHeartbeat: false,
          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
          });


          }
          });






          Akshhayah Mahurkar is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f501521%2fi-want-to-compare-two-files-and-get-the-difference-in-new-file-with-the-changed%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Akshhayah Mahurkar is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Akshhayah Mahurkar is a new contributor. Be nice, and check out our Code of Conduct.













          Akshhayah Mahurkar is a new contributor. Be nice, and check out our Code of Conduct.












          Akshhayah Mahurkar is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Unix & Linux Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f501521%2fi-want-to-compare-two-files-and-get-the-difference-in-new-file-with-the-changed%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Accessing regular linux commands in Huawei's Dopra Linux

          Can't connect RFCOMM socket: Host is down

          Kernel panic - not syncing: Fatal Exception in Interrupt