Question about text formating using sed of awk The 2019 Stack Overflow Developer Survey Results Are In 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 ResultsUsing sed/awk to remove anything after first spacesed remove last space only on end of line,combined with awkUsing sed / awk to change words between two patternssed append a text with many lines after matching of multiple strings while the text remains many lines in sed commandRegex: using awk and sed to match websites by IPSelecting text from a file removing unwanted text using shellAWK/SED Remove a specific latex command from the text AND closing bracket behind itAwk to remove extra space after first letter?How to remove n from a column using awk or sedDeleting portion of a text file and following lines using sed

For what reasons would an animal species NOT cross a *horizontal* land bridge?

Match Roman Numerals

Can each chord in a progression create its own key?

Do I have Disadvantage attacking with an off-hand weapon?

Why not take a picture of a closer black hole?

Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?

What happens to a Warlock's expended Spell Slots when they gain a Level?

How did passengers keep warm on sail ships?

Why did Peik Lin say, "I'm not an animal"?

Is 'stolen' appropriate word?

How did the crowd guess the pentatonic scale in Bobby McFerrin's presentation?

Windows 10: How to Lock (not sleep) laptop on lid close?

Do warforged have souls?

how can a perfect fourth interval be considered either consonant or dissonant?

What other Star Trek series did the main TNG cast show up in?

What force causes entropy to increase?

ELI5: Why do they say that Israel would have been the fourth country to land a spacecraft on the Moon and why do they call it low cost?

What do I do when my TA workload is more than expected?

Was credit for the black hole image misappropriated?

How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time

What information about me do stores get via my credit card?

Accepted by European university, rejected by all American ones I applied to? Possible reasons?

"... to apply for a visa" or "... and applied for a visa"?

What to do when moving next to a bird sanctuary with a loosely-domesticated cat?



Question about text formating using sed of awk



The 2019 Stack Overflow Developer Survey Results Are In
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 ResultsUsing sed/awk to remove anything after first spacesed remove last space only on end of line,combined with awkUsing sed / awk to change words between two patternssed append a text with many lines after matching of multiple strings while the text remains many lines in sed commandRegex: using awk and sed to match websites by IPSelecting text from a file removing unwanted text using shellAWK/SED Remove a specific latex command from the text AND closing bracket behind itAwk to remove extra space after first letter?How to remove n from a column using awk or sedDeleting portion of a text file and following lines using sed



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








1















I want to format text using awk or sed.
I have text looking like, 



H1 (dxfault)
H337 (Unxr)
H1106 (hast)
H1129 (h1129)
H1370 (hlan1370)


I want to remove the letter H and everything after the first space, and format numbers look like 1,337,1106,1129,1370



I found two different sed options



First:



sed 'y/H/ /' #for removing H letter in front


Second:



sed 's/s.*$//' #for removing everything after first break "space"


How can I combine these commands and add comma after numbers?






linux text-processing awk sed scripting







share|improve this question









New contributor




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


























    1















    I want to format text using awk or sed.
    I have text looking like, 



    H1 (dxfault)
    H337 (Unxr)
    H1106 (hast)
    H1129 (h1129)
    H1370 (hlan1370)


    I want to remove the letter H and everything after the first space, and format numbers look like 1,337,1106,1129,1370



    I found two different sed options



    First:



    sed 'y/H/ /' #for removing H letter in front


    Second:



    sed 's/s.*$//' #for removing everything after first break "space"


    How can I combine these commands and add comma after numbers?






    linux text-processing awk sed scripting







    share|improve this question









    New contributor




    Giunter 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 want to format text using awk or sed.
      I have text looking like, 



      H1 (dxfault)
      H337 (Unxr)
      H1106 (hast)
      H1129 (h1129)
      H1370 (hlan1370)


      I want to remove the letter H and everything after the first space, and format numbers look like 1,337,1106,1129,1370



      I found two different sed options



      First:



      sed 'y/H/ /' #for removing H letter in front


      Second:



      sed 's/s.*$//' #for removing everything after first break "space"


      How can I combine these commands and add comma after numbers?






      linux text-processing awk sed scripting







      share|improve this question









      New contributor




      Giunter 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 format text using awk or sed.
      I have text looking like, 



      H1 (dxfault)
      H337 (Unxr)
      H1106 (hast)
      H1129 (h1129)
      H1370 (hlan1370)


      I want to remove the letter H and everything after the first space, and format numbers look like 1,337,1106,1129,1370



      I found two different sed options



      First:



      sed 'y/H/ /' #for removing H letter in front


      Second:



      sed 's/s.*$//' #for removing everything after first break "space"


      How can I combine these commands and add comma after numbers?






      linux text-processing awk sed scripting




      linux text-processing awk sed scripting






      share|improve this question









      New contributor




      Giunter 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




      Giunter 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 yesterday









      Tejas

      1,86422041




      1,86422041






      New contributor




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









      asked yesterday









      GiunterGiunter

      62




      62




      New contributor




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





      New contributor





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






      Giunter 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


















          3














          You can use sed to get the numbers only and paste to merge the lines with , as delimiter:



          sed -E 's/^H([0-9]*).*$/1/' file | paste -sd,


          or grep and paste:



          grep -Po '^HK[0-9]*' file | paste -sd,
          grep -o '^H[0-9]*' file | cut -c 2- | paste -sd,


          You can exchange the linebreak with , with sed, but imo paste is easier.






          share|improve this answer























          • hi.. can you tell me why can't we use or(|) operator sed -E 's/^H|s.*$/1/' also what does 1 and () mean?

            – Goron
            yesterday











          • You can't use |, because you want to match ^H at the beginning and s.*$ at the end of the line which are two matches (not one or the other). () is used to group the matches and 1 is a backreference to the first group in the replacement. See for example sed -E 's/(^H)(.*)(s.*$)/1:1 2:2 3:3/' file which uses 3 groups and backreferences.

            – Freddy
            yesterday



















          0














          Or sed/grep using tr:



          $ sed -E 's/H([0-9]+).*/1/' file | tr 'n' ,

          $ grep -o '[0-9]+s' file | tr -s 'n ' ,



          • tr 'n' , replaces newline with comma


          • tr -s 'n ' , replaces newline and space with one comma





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



            );






            Giunter 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%2f511829%2fquestion-about-text-formating-using-sed-of-awk%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









            3














            You can use sed to get the numbers only and paste to merge the lines with , as delimiter:



            sed -E 's/^H([0-9]*).*$/1/' file | paste -sd,


            or grep and paste:



            grep -Po '^HK[0-9]*' file | paste -sd,
            grep -o '^H[0-9]*' file | cut -c 2- | paste -sd,


            You can exchange the linebreak with , with sed, but imo paste is easier.






            share|improve this answer























            • hi.. can you tell me why can't we use or(|) operator sed -E 's/^H|s.*$/1/' also what does 1 and () mean?

              – Goron
              yesterday











            • You can't use |, because you want to match ^H at the beginning and s.*$ at the end of the line which are two matches (not one or the other). () is used to group the matches and 1 is a backreference to the first group in the replacement. See for example sed -E 's/(^H)(.*)(s.*$)/1:1 2:2 3:3/' file which uses 3 groups and backreferences.

              – Freddy
              yesterday
















            3














            You can use sed to get the numbers only and paste to merge the lines with , as delimiter:



            sed -E 's/^H([0-9]*).*$/1/' file | paste -sd,


            or grep and paste:



            grep -Po '^HK[0-9]*' file | paste -sd,
            grep -o '^H[0-9]*' file | cut -c 2- | paste -sd,


            You can exchange the linebreak with , with sed, but imo paste is easier.






            share|improve this answer























            • hi.. can you tell me why can't we use or(|) operator sed -E 's/^H|s.*$/1/' also what does 1 and () mean?

              – Goron
              yesterday











            • You can't use |, because you want to match ^H at the beginning and s.*$ at the end of the line which are two matches (not one or the other). () is used to group the matches and 1 is a backreference to the first group in the replacement. See for example sed -E 's/(^H)(.*)(s.*$)/1:1 2:2 3:3/' file which uses 3 groups and backreferences.

              – Freddy
              yesterday














            3












            3








            3







            You can use sed to get the numbers only and paste to merge the lines with , as delimiter:



            sed -E 's/^H([0-9]*).*$/1/' file | paste -sd,


            or grep and paste:



            grep -Po '^HK[0-9]*' file | paste -sd,
            grep -o '^H[0-9]*' file | cut -c 2- | paste -sd,


            You can exchange the linebreak with , with sed, but imo paste is easier.






            share|improve this answer













            You can use sed to get the numbers only and paste to merge the lines with , as delimiter:



            sed -E 's/^H([0-9]*).*$/1/' file | paste -sd,


            or grep and paste:



            grep -Po '^HK[0-9]*' file | paste -sd,
            grep -o '^H[0-9]*' file | cut -c 2- | paste -sd,


            You can exchange the linebreak with , with sed, but imo paste is easier.







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered yesterday









            RoVoRoVo

            3,761317




            3,761317












            • hi.. can you tell me why can't we use or(|) operator sed -E 's/^H|s.*$/1/' also what does 1 and () mean?

              – Goron
              yesterday











            • You can't use |, because you want to match ^H at the beginning and s.*$ at the end of the line which are two matches (not one or the other). () is used to group the matches and 1 is a backreference to the first group in the replacement. See for example sed -E 's/(^H)(.*)(s.*$)/1:1 2:2 3:3/' file which uses 3 groups and backreferences.

              – Freddy
              yesterday


















            • hi.. can you tell me why can't we use or(|) operator sed -E 's/^H|s.*$/1/' also what does 1 and () mean?

              – Goron
              yesterday











            • You can't use |, because you want to match ^H at the beginning and s.*$ at the end of the line which are two matches (not one or the other). () is used to group the matches and 1 is a backreference to the first group in the replacement. See for example sed -E 's/(^H)(.*)(s.*$)/1:1 2:2 3:3/' file which uses 3 groups and backreferences.

              – Freddy
              yesterday

















            hi.. can you tell me why can't we use or(|) operator sed -E 's/^H|s.*$/1/' also what does 1 and () mean?

            – Goron
            yesterday





            hi.. can you tell me why can't we use or(|) operator sed -E 's/^H|s.*$/1/' also what does 1 and () mean?

            – Goron
            yesterday













            You can't use |, because you want to match ^H at the beginning and s.*$ at the end of the line which are two matches (not one or the other). () is used to group the matches and 1 is a backreference to the first group in the replacement. See for example sed -E 's/(^H)(.*)(s.*$)/1:1 2:2 3:3/' file which uses 3 groups and backreferences.

            – Freddy
            yesterday






            You can't use |, because you want to match ^H at the beginning and s.*$ at the end of the line which are two matches (not one or the other). () is used to group the matches and 1 is a backreference to the first group in the replacement. See for example sed -E 's/(^H)(.*)(s.*$)/1:1 2:2 3:3/' file which uses 3 groups and backreferences.

            – Freddy
            yesterday














            0














            Or sed/grep using tr:



            $ sed -E 's/H([0-9]+).*/1/' file | tr 'n' ,

            $ grep -o '[0-9]+s' file | tr -s 'n ' ,



            • tr 'n' , replaces newline with comma


            • tr -s 'n ' , replaces newline and space with one comma





            share|improve this answer



























              0














              Or sed/grep using tr:



              $ sed -E 's/H([0-9]+).*/1/' file | tr 'n' ,

              $ grep -o '[0-9]+s' file | tr -s 'n ' ,



              • tr 'n' , replaces newline with comma


              • tr -s 'n ' , replaces newline and space with one comma





              share|improve this answer

























                0












                0








                0







                Or sed/grep using tr:



                $ sed -E 's/H([0-9]+).*/1/' file | tr 'n' ,

                $ grep -o '[0-9]+s' file | tr -s 'n ' ,



                • tr 'n' , replaces newline with comma


                • tr -s 'n ' , replaces newline and space with one comma





                share|improve this answer













                Or sed/grep using tr:



                $ sed -E 's/H([0-9]+).*/1/' file | tr 'n' ,

                $ grep -o '[0-9]+s' file | tr -s 'n ' ,



                • tr 'n' , replaces newline with comma


                • tr -s 'n ' , replaces newline and space with one comma






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered yesterday









                FreddyFreddy

                1,632210




                1,632210




















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









                    draft saved

                    draft discarded


















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












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











                    Giunter 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%2f511829%2fquestion-about-text-formating-using-sed-of-awk%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, linux, scripting, sed, text-processing
                    -

                    Popular posts from this blog

                    Creating 100m^2 grid automatically using QGIS?Creating grid constrained within polygon in QGIS?Createing polygon layer from point data using QGIS?Creating vector grid using QGIS?Creating grid polygons from coordinates using R or PythonCreating grid from spatio temporal point data?Creating fields in attributes table using other layers using QGISCreate .shp vector grid in QGISQGIS Creating 4km point grid within polygonsCreate a vector grid over a raster layerVector Grid Creates just one grid

                    Image
                    Pattern match does not work in bash script Mage Armor with Defense fighting style (for Adventurers League bladeslinger) LaTeX closing $ signs makes cursor jump String Manipulation Interpreter Can divisibility rules for digits be generalized to sum of digits I'm planning on buying a laser printer but concerned about the life cycle of toner in the machine What is the offset in a seaplane's hull? How can I make my BBEG immortal short of making them a Lich or Vampire? What are the differences between the usage of 'it' and 'they'? The use of multiple foreign keys on same column in SQL Server How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy? Is it tax fraud for an individual to declare non-taxable revenue as taxable income? (US tax laws) Why Is Death Allowed In the Matrix? Minkowski space Why are 150k or 200k jobs considered good when there are 300k+ births a month? Why do f...
                    Read more

                    Why is this plane circling around the Lucknow airport every day?Why do aircraft on Flight Radar 24 jump around randomly sometimes?What airport has this walkway over a taxiway?How does Chicago O'Hare's tower sequence aircraft at peak capacity?Which airport is featured in this Delta commercial?After a crash, for how long is the airport closed?Can a passenger plane stand still in the air, or hover at a fixed location above a ground?What are those trucks towing around, and why?What is this airport outside of Cairo, Egypt?Which US airport has the lowest circling MDH?What is this airport video?

                    Image
                    Freedom of speech and where it applies THT: What is a squared annular “ring”? Hot bath for aluminium engine block and heads Delete database accidentally by a bash, rescue please Why do IPv6 unique local addresses have to have a /48 prefix? How can Trident be so inexpensive? Will it orbit Triton or just do a (slow) flyby? Customize circled numbers Drawing ramified coverings with tikz How does the reference system of the Majjhima Nikaya work? Why did the EU agree to delay the Brexit deadline? Melting point of aspirin, contradicting sources Is Asuka Langley-Soryu disgusted by Shinji? Did US corporations pay demonstrators in the German demonstrations against article 13? Is camera lens focus an exact point or a range? Does a 'pending' US visa application constitute a denial? GraphicsGrid with a Label for each Column and Row How do you respond to a colleague from another team when they're wrongly expecting that you'll help them? How is flybla...
                    Read more

                    Nikolai Prilezhaev Bibliography References External links Navigation menuEarly Russian Organic Chemists and Their Legacy092774english translationRussian Biography

                    19th-century chemists20th-century chemists1877 births1944 deathsRussian chemists RussianO.S.KopossevoNizhny NovgorodMoscoworganic chemistPrilezhaev ReactionepoxidesalkenesperoxyacidsUniversity of WarsawYegor Yegorovich VagnerGeorg WagnerSt. PetersburgPolytechnic in KievUniversity of MinskBelarusian Academy of SciencesAlexei Nikolaevich Bachname reactionSoviet Academy of Sciences Nikolai Alexandrovich Prilezhaev , Russian: Николай Александрович Прилежаев , (Born 15 [O.S. 1877] 27 [1] in Kopossevo near Nizhny Novgorod, died May 26, 1944 in Moscow) was a Russian organic chemist. The Prilezhaev Reaction between epoxides and alkenes to form peroxyacids is named after him. Prilezhaev was the son of a clergyman and studied chemistry at the Theological Seminary in Warsaw (graduated in 1895) and then at the Univ...
                    Read more