Append field to csv based on conditional search from another file

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP












0














Trying to append a field at the end of a large CSV file with server records:



30522,sysserver0012-softlayer.com,RDDP_Place-Live_Migration_Service-LT- 
TOPSINTP-787,x86_64,8,8,VMware Virtual Platform,VMW Guest,CentOS Linux
release,7.2.1511 (Core) ,JDK,1.8.0_111,openjdk


I will be adding the ESX hosts where each server is, so that is another file with those records



Add something like btesxid432.eu.domain.com when you get a match for the server in the second file, in this case sysserver0012 even though you do not get the FQDN, so for this case:



30522,sysserver0012-softlayer.com,RDDP_Place-Live_Migration_Service-LT- 
TOPSINTP-787,x86_64,8,8,VMware Virtual Platform,VMW Guest,CentOS Linux
release
7.2.1511 (Core) ,JDK,1.8.0_111,openjdk,btesxid432.eu.domain.com









share|improve this question


























    0














    Trying to append a field at the end of a large CSV file with server records:



    30522,sysserver0012-softlayer.com,RDDP_Place-Live_Migration_Service-LT- 
    TOPSINTP-787,x86_64,8,8,VMware Virtual Platform,VMW Guest,CentOS Linux
    release,7.2.1511 (Core) ,JDK,1.8.0_111,openjdk


    I will be adding the ESX hosts where each server is, so that is another file with those records



    Add something like btesxid432.eu.domain.com when you get a match for the server in the second file, in this case sysserver0012 even though you do not get the FQDN, so for this case:



    30522,sysserver0012-softlayer.com,RDDP_Place-Live_Migration_Service-LT- 
    TOPSINTP-787,x86_64,8,8,VMware Virtual Platform,VMW Guest,CentOS Linux
    release
    7.2.1511 (Core) ,JDK,1.8.0_111,openjdk,btesxid432.eu.domain.com









    share|improve this question
























      0












      0








      0







      Trying to append a field at the end of a large CSV file with server records:



      30522,sysserver0012-softlayer.com,RDDP_Place-Live_Migration_Service-LT- 
      TOPSINTP-787,x86_64,8,8,VMware Virtual Platform,VMW Guest,CentOS Linux
      release,7.2.1511 (Core) ,JDK,1.8.0_111,openjdk


      I will be adding the ESX hosts where each server is, so that is another file with those records



      Add something like btesxid432.eu.domain.com when you get a match for the server in the second file, in this case sysserver0012 even though you do not get the FQDN, so for this case:



      30522,sysserver0012-softlayer.com,RDDP_Place-Live_Migration_Service-LT- 
      TOPSINTP-787,x86_64,8,8,VMware Virtual Platform,VMW Guest,CentOS Linux
      release
      7.2.1511 (Core) ,JDK,1.8.0_111,openjdk,btesxid432.eu.domain.com









      share|improve this question













      Trying to append a field at the end of a large CSV file with server records:



      30522,sysserver0012-softlayer.com,RDDP_Place-Live_Migration_Service-LT- 
      TOPSINTP-787,x86_64,8,8,VMware Virtual Platform,VMW Guest,CentOS Linux
      release,7.2.1511 (Core) ,JDK,1.8.0_111,openjdk


      I will be adding the ESX hosts where each server is, so that is another file with those records



      Add something like btesxid432.eu.domain.com when you get a match for the server in the second file, in this case sysserver0012 even though you do not get the FQDN, so for this case:



      30522,sysserver0012-softlayer.com,RDDP_Place-Live_Migration_Service-LT- 
      TOPSINTP-787,x86_64,8,8,VMware Virtual Platform,VMW Guest,CentOS Linux
      release
      7.2.1511 (Core) ,JDK,1.8.0_111,openjdk,btesxid432.eu.domain.com






      linux csv






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Dec 11 at 17:11









      XtC

      62




      62

























          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
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f487398%2fappend-field-to-csv-based-on-conditional-search-from-another-file%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown






























          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          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.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • 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%2f487398%2fappend-field-to-csv-based-on-conditional-search-from-another-file%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

          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?