Join two files based on bakery code

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











up vote
0
down vote

favorite












I have two files I would like to join based on the bakery store number.



[File 1] bakedGoods.txt



1:Chocolate Cookies:111
2:Banana Muffins:222
3:Apple Pie:333
4:Strawberry Cheesecake:444
5:Pineapple Turnover:555


Where column 1 is the number of the item, column 2 is the item name, and column 3 is the store number.



[File 2] bakeryStores.txt



111:Cookies Cookies Cookies
222:Bellas Desserts Co.
333:Apples N' Sweets
444:Cheesecake Emporium
777:Estrellas Bakery
888:Suzy's Baked Goods


Where column 1 is the bakery store number and column 2 is the name of the bakery.



My goal is to join the information that has the same bakery store number by using the join command (I assume that is the best way). This means column 3 for file 1 and column 1 for file 2. As well as display a message "Not in store" for the empty fields that are not pair-able. (Which I assume using the option -e"Not in store" is the best way to go. The below is what I am trying to achieve.



111:Chocolate Cookies:Cookies Cookies Cookies
222:Banana Muffins:Bellas Desserts Co.
333:Apple Pie:Apples N' Sweets
444:Strawberry Cheesecake:Cheesecake Emporium
Not in store
Not in store


I try to join the two files by store number, using the -e option, but nothing changes. I see no output either.









share

























    up vote
    0
    down vote

    favorite












    I have two files I would like to join based on the bakery store number.



    [File 1] bakedGoods.txt



    1:Chocolate Cookies:111
    2:Banana Muffins:222
    3:Apple Pie:333
    4:Strawberry Cheesecake:444
    5:Pineapple Turnover:555


    Where column 1 is the number of the item, column 2 is the item name, and column 3 is the store number.



    [File 2] bakeryStores.txt



    111:Cookies Cookies Cookies
    222:Bellas Desserts Co.
    333:Apples N' Sweets
    444:Cheesecake Emporium
    777:Estrellas Bakery
    888:Suzy's Baked Goods


    Where column 1 is the bakery store number and column 2 is the name of the bakery.



    My goal is to join the information that has the same bakery store number by using the join command (I assume that is the best way). This means column 3 for file 1 and column 1 for file 2. As well as display a message "Not in store" for the empty fields that are not pair-able. (Which I assume using the option -e"Not in store" is the best way to go. The below is what I am trying to achieve.



    111:Chocolate Cookies:Cookies Cookies Cookies
    222:Banana Muffins:Bellas Desserts Co.
    333:Apple Pie:Apples N' Sweets
    444:Strawberry Cheesecake:Cheesecake Emporium
    Not in store
    Not in store


    I try to join the two files by store number, using the -e option, but nothing changes. I see no output either.









    share























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I have two files I would like to join based on the bakery store number.



      [File 1] bakedGoods.txt



      1:Chocolate Cookies:111
      2:Banana Muffins:222
      3:Apple Pie:333
      4:Strawberry Cheesecake:444
      5:Pineapple Turnover:555


      Where column 1 is the number of the item, column 2 is the item name, and column 3 is the store number.



      [File 2] bakeryStores.txt



      111:Cookies Cookies Cookies
      222:Bellas Desserts Co.
      333:Apples N' Sweets
      444:Cheesecake Emporium
      777:Estrellas Bakery
      888:Suzy's Baked Goods


      Where column 1 is the bakery store number and column 2 is the name of the bakery.



      My goal is to join the information that has the same bakery store number by using the join command (I assume that is the best way). This means column 3 for file 1 and column 1 for file 2. As well as display a message "Not in store" for the empty fields that are not pair-able. (Which I assume using the option -e"Not in store" is the best way to go. The below is what I am trying to achieve.



      111:Chocolate Cookies:Cookies Cookies Cookies
      222:Banana Muffins:Bellas Desserts Co.
      333:Apple Pie:Apples N' Sweets
      444:Strawberry Cheesecake:Cheesecake Emporium
      Not in store
      Not in store


      I try to join the two files by store number, using the -e option, but nothing changes. I see no output either.









      share













      I have two files I would like to join based on the bakery store number.



      [File 1] bakedGoods.txt



      1:Chocolate Cookies:111
      2:Banana Muffins:222
      3:Apple Pie:333
      4:Strawberry Cheesecake:444
      5:Pineapple Turnover:555


      Where column 1 is the number of the item, column 2 is the item name, and column 3 is the store number.



      [File 2] bakeryStores.txt



      111:Cookies Cookies Cookies
      222:Bellas Desserts Co.
      333:Apples N' Sweets
      444:Cheesecake Emporium
      777:Estrellas Bakery
      888:Suzy's Baked Goods


      Where column 1 is the bakery store number and column 2 is the name of the bakery.



      My goal is to join the information that has the same bakery store number by using the join command (I assume that is the best way). This means column 3 for file 1 and column 1 for file 2. As well as display a message "Not in store" for the empty fields that are not pair-able. (Which I assume using the option -e"Not in store" is the best way to go. The below is what I am trying to achieve.



      111:Chocolate Cookies:Cookies Cookies Cookies
      222:Banana Muffins:Bellas Desserts Co.
      333:Apple Pie:Apples N' Sweets
      444:Strawberry Cheesecake:Cheesecake Emporium
      Not in store
      Not in store


      I try to join the two files by store number, using the -e option, but nothing changes. I see no output either.







      linux bash join





      share












      share










      share



      share










      asked 1 min ago









      Isabel Estrella Sanchez

      11




      11

























          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: false,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          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%2f477133%2fjoin-two-files-based-on-bakery-code%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%2f477133%2fjoin-two-files-based-on-bakery-code%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?