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?










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?










    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?










      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






      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

                    Word for a person who has no opinion about whether god existsWord for having a definite opinion while simultaneously withholding judgment?What's the opposite of “newcomer? Is ”veteran" OK?What do you call an “atheist” who might believe in an afterlife?What's a word for someone who wants to voice opinions but not have them challenged?Word for someone who dismisses contrary opinions as irrational?Somone who thinks they are overly special/out of the ordinaryIs there a word, phrase or idiom for “a person who is incapable of thinking about the future”?The belief that a god is human-likeA word for a non-famous person/thing you have heard a lot aboutAdjective for a person who enjoys taking care of their appearance

                    2017 IndyCar Series Contents Series news Teams and drivers Schedule Season summary Footnotes References External links Navigation menu"INDYCAR: Initial 2018 bodywork concepts unveiled"the original"IndyCar confirms switch to Performance Friction brakes in 2017""AJ Foyt Racing will switch to Chevy"the original"Carlos Munoz, Conor Daly will drive for AJ Foyt Racing""Zach Veach's Indy 500 Debut Confirmed with Foyt""No mass exodus from Honda after Ganassi switch""Ex-F1 driver Sato joins Andretti Autosport for 2017 IndyCar season""IndyCar's Ryan Hunter-Reay, sponsor DHL paired through 2020""hhgregg and Andretti Autosport announce partnership for key races in 2016""INDYCAR: Rossi re-signs with Andretti"the original"McLaren Formula 1 - Fernando Alonso to race at Indy 500 with McLaren, Honda and Andretti Autosport""Shank will finally take part in Indy 500 with Harvey, Andretti | MotorSportsTalk""Andretti adds Jack Harvey to Indy 500 field""Ganassi switches to Honda power for 2017""INDYCAR: Chilton returns to Ganassi"the original"IndyCar silly season: Who's going where in 2017?""INDYCAR: Kanaan, NTT Data return to Ganassi"the original"Kimball to remain at Ganassi for 2017""Coyne confirms Bourdais for 2017 IndyCar season""Davison to sub for Bourdais in Indy 500"the original"Gutierrez confirmed for Detroit IndyCar debut""Gutierrez returns with Coyne for rest of 2017 season""Vautier to drive for Coyne at Texas"the original"INDYCAR: Coyne confirms Jones for 2017"the original"Pippa Mann returns to Coyne for Indy 500""Karam, Dreyer & Reinbold teaming up again for Indianapolis 500""Pigot to return to Ed Carpenter Racing""Hildebrand confirmed as full-time Ed Carpenter driver""Veach to replace injured Hildebrand at Barber"the originalNew Team Harding Racing Enters Chaves for 101st Indianapolis 500"Juncos Racing Announces Entry in 101st Running of the Indianapolis 500 :: Juncos Racing""Juncos confirms Pigot for Indy 500""Saavedra confirmed in Juncos' second 500 entry"the original"Lazier confirms Indy 500 run after son's USF2000 debut"the original"Claman DeMelo to race for RLLR at Sonoma"the original"Rahal signs Servia and ace engineer for 2017""IndyCar: Aleshin returns with Schmidt"the original"Aleshin replaced by Saavedra for Toronto""Jack Harvey will pilot SPM No. 7 car at Watkins Glen, Sonoma""Jay Howard confirmed in Tony Stewart's supported SPM Indy entry""INDYCAR: Newgarden to wave the flag at Penske"the original"Pagenaud opts for No. 1 in 2017"the original"Penske confirms Newgarden for 2017""Montoya to stay with Team Penske in 2017""Target leaving IndyCar after 27 seasons with Chip Ganassi""Cavin: IndyCar could see complete driver/team shakeup in 2017""End of the road for KV Racing?""KV Racing confirms closure, equipment sold to Juncos""Juncos confirms IndyCar Series entry"the original"Juncos readies IndyCar program, aims for '17 500"the original"Harding Racing to add Texas, Pocono to schedule"the original"Sato signs with Andretti Autosport for 2017""INDYCAR: Aleshin in Doubt at SPM"the original"Long Beach notebook: JR Hildebrand breaks hand""Hildebrand cleared to return at Phoenix"the original"Bourdais to undergo surgery on multiple fractures""Aleshin loses Schmidt Peterson IndyCar ride""Saavedra in at SPM for Pocono, Gateway"the original"Bourdais to make return at Gateway"the original"The IndyCar Grand Prix no longer is sponsored by Angie's List""2017 IndyCar Series rulebook""2017 Verizon IndyCar Series Official Rulebook"Official websiteeeeee

                    What was this official D&D 3.5e Lovecraft-flavored rulebook?What was this set of RPG tools called?As a first-time DM should I let my players play complex character classes and roles?Nymph's Kiss and the RelationshipWhat was the name of this Cleric Prestige Class that shapes metal with its bare hands?Are the 3.5e Dragonlance books third party or official works?What's up with the domain Vile Darkness?What was this 80s book about RPGs?What was the name of this Werewolf band?What book had Rituals to “upgrade” animal companions to keep them viable at higher levels?What was this RPG that had rules for player-owned businesses?