extract specific fields from a file using a character delimiter Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) 2019 Community Moderator Election Results Why I closed the “Why is Kali so hard” questionPrint fields from file only if line starts with a specific wordConcatenating fields from lines with different numbers of fieldsRead a column from a file and append a specific column of another filePrint out the file with cancel certain character and transfer into another existing filegawk - Dynamic creation of text file using input file fieldsGet the rows only with specific fieldsAwk: remove first few fields from CSVExtract substring after delimiter using GNU awk or awkFormat Date fields in Pipe Delimited FileHow to get the rows with non-zero value in specific columns in a pipe delimited file using awk?

Why did the IBM 650 use bi-quinary?

Why didn't this character "real die" when they blew their stack out in Altered Carbon?

51k Euros annually for a family of 4 in Berlin: Is it enough?

Why aren't air breathing engines used as small first stages

What is a non-alternating simple group with big order, but relatively few conjugacy classes?

What does an IRS interview request entail when called in to verify expenses for a sole proprietor small business?

Why do people hide their license plates in the EU?

What's the purpose of writing one's academic biography in the third person?

Why are Kinder Surprise Eggs illegal in the USA?

Can an alien society believe that their star system is the universe?

Why was the term "discrete" used in discrete logarithm?

Single word antonym of "flightless"

Should I discuss the type of campaign with my players?

How do I keep my slimes from escaping their pens?

3 doors, three guards, one stone

How to react to hostile behavior from a senior developer?

What is the logic behind the Maharil's explanation of why we don't say שעשה ניסים on Pesach?

Can I cast Passwall to drop an enemy into a 20-foot pit?

How does the particle を relate to the verb 行く in the structure「A を + B に行く」?

When were vectors invented?

Should I use a zero-interest credit card for a large one-time purchase?

List *all* the tuples!

If a contract sometimes uses the wrong name, is it still valid?

Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?



extract specific fields from a file using a character delimiter



Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
2019 Community Moderator Election Results
Why I closed the “Why is Kali so hard” questionPrint fields from file only if line starts with a specific wordConcatenating fields from lines with different numbers of fieldsRead a column from a file and append a specific column of another filePrint out the file with cancel certain character and transfer into another existing filegawk - Dynamic creation of text file using input file fieldsGet the rows only with specific fieldsAwk: remove first few fields from CSVExtract substring after delimiter using GNU awk or awkFormat Date fields in Pipe Delimited FileHow to get the rows with non-zero value in specific columns in a pipe delimited file using awk?



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








-1















I have a 1gb file and would like to get the third and fifth fields.



The file is delimited by (,):



input file:



luis, jose, jesus atoche, mark, john
1,2,3,4,5
aa 1, bb 2, cc3, dd 4, ee5


output file:



jesus atoche, john
3.5
  cc3, ee5


I understand that it can be done with the awk commands.



THANKS!










share|improve this question









New contributor




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


























    -1















    I have a 1gb file and would like to get the third and fifth fields.



    The file is delimited by (,):



    input file:



    luis, jose, jesus atoche, mark, john
    1,2,3,4,5
    aa 1, bb 2, cc3, dd 4, ee5


    output file:



    jesus atoche, john
    3.5
      cc3, ee5


    I understand that it can be done with the awk commands.



    THANKS!










    share|improve this question









    New contributor




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






















      -1












      -1








      -1








      I have a 1gb file and would like to get the third and fifth fields.



      The file is delimited by (,):



      input file:



      luis, jose, jesus atoche, mark, john
      1,2,3,4,5
      aa 1, bb 2, cc3, dd 4, ee5


      output file:



      jesus atoche, john
      3.5
        cc3, ee5


      I understand that it can be done with the awk commands.



      THANKS!










      share|improve this question









      New contributor




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












      I have a 1gb file and would like to get the third and fifth fields.



      The file is delimited by (,):



      input file:



      luis, jose, jesus atoche, mark, john
      1,2,3,4,5
      aa 1, bb 2, cc3, dd 4, ee5


      output file:



      jesus atoche, john
      3.5
        cc3, ee5


      I understand that it can be done with the awk commands.



      THANKS!







      text-processing awk gawk mawk






      share|improve this question









      New contributor




      Luis Pucutay 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




      Luis Pucutay 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 10 hours ago









      msp9011

      4,70844167




      4,70844167






      New contributor




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









      asked 10 hours ago









      Luis PucutayLuis Pucutay

      31




      31




      New contributor




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





      New contributor





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






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




















          2 Answers
          2






          active

          oldest

          votes


















          0














          Something in the lines of



          awk 'BEGINFS=","; OFS="," print $3, $5' input_file.csv > output_file.csv


          Should work






          share|improve this answer






























            0














            Try awk -F"," 'print $3","$5' <input file name>






            share|improve this answer























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



              );






              Luis Pucutay 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%2f512831%2fextract-specific-fields-from-a-file-using-a-character-delimiter%23new-answer', 'question_page');

              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              0














              Something in the lines of



              awk 'BEGINFS=","; OFS="," print $3, $5' input_file.csv > output_file.csv


              Should work






              share|improve this answer



























                0














                Something in the lines of



                awk 'BEGINFS=","; OFS="," print $3, $5' input_file.csv > output_file.csv


                Should work






                share|improve this answer

























                  0












                  0








                  0







                  Something in the lines of



                  awk 'BEGINFS=","; OFS="," print $3, $5' input_file.csv > output_file.csv


                  Should work






                  share|improve this answer













                  Something in the lines of



                  awk 'BEGINFS=","; OFS="," print $3, $5' input_file.csv > output_file.csv


                  Should work







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 10 hours ago









                  RafareinoRafareino

                  1909




                  1909























                      0














                      Try awk -F"," 'print $3","$5' <input file name>






                      share|improve this answer



























                        0














                        Try awk -F"," 'print $3","$5' <input file name>






                        share|improve this answer

























                          0












                          0








                          0







                          Try awk -F"," 'print $3","$5' <input file name>






                          share|improve this answer













                          Try awk -F"," 'print $3","$5' <input file name>







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered 10 hours ago









                          upkarupkar

                          163110




                          163110




















                              Luis Pucutay is a new contributor. Be nice, and check out our Code of Conduct.









                              draft saved

                              draft discarded


















                              Luis Pucutay is a new contributor. Be nice, and check out our Code of Conduct.












                              Luis Pucutay is a new contributor. Be nice, and check out our Code of Conduct.











                              Luis Pucutay 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%2f512831%2fextract-specific-fields-from-a-file-using-a-character-delimiter%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







                              -awk, gawk, mawk, text-processing

                              Popular posts from this blog

                              Frič See also Navigation menuinternal link

                              Identify plant with long narrow paired leaves and reddish stems Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?What is this plant with long sharp leaves? Is it a weed?What is this 3ft high, stalky plant, with mid sized narrow leaves?What is this young shrub with opposite ovate, crenate leaves and reddish stems?What is this plant with large broad serrated leaves?Identify this upright branching weed with long leaves and reddish stemsPlease help me identify this bulbous plant with long, broad leaves and white flowersWhat is this small annual with narrow gray/green leaves and rust colored daisy-type flowers?What is this chilli plant?Does anyone know what type of chilli plant this is?Help identify this plant

                              fontconfig warning: “/etc/fonts/fonts.conf”, line 100: unknown “element blank” The 2019 Stack Overflow Developer Survey Results Are In“tar: unrecognized option --warning” during 'apt-get install'How to fix Fontconfig errorHow do I figure out which font file is chosen for a system generic font alias?Why are some apt-get-installed fonts being ignored by fc-list, xfontsel, etc?Reload settings in /etc/fonts/conf.dTaking 30 seconds longer to boot after upgrade from jessie to stretchHow to match multiple font names with a single <match> element?Adding a custom font to fontconfigRemoving fonts from fontconfig <match> resultsBroken fonts after upgrading Firefox ESR to latest Firefox