How to get a string untill second occurence of “-” and number












1















An example: prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000



I still need value till prod2-03_dl-httpd-prod
So basically we need value till second occurrence of '-' and number.



We tried following options:- 



echo "prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000" | sed -r 's/([^-][:digit:]+[^-][:digit:]).*/1/'





regex unix







share|improve this question

























  • You should probably read this: stackoverflow.com/help/someone-answers

    – James Brown
    Nov 22 '18 at 9:42











  • See my awk approach, it might turn out more robust that grep here.

    – Wiktor Stribiżew
    Nov 22 '18 at 10:16
















1















An example: prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000



I still need value till prod2-03_dl-httpd-prod
So basically we need value till second occurrence of '-' and number.



We tried following options:- 



echo "prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000" | sed -r 's/([^-][:digit:]+[^-][:digit:]).*/1/'





regex unix







share|improve this question

























  • You should probably read this: stackoverflow.com/help/someone-answers

    – James Brown
    Nov 22 '18 at 9:42











  • See my awk approach, it might turn out more robust that grep here.

    – Wiktor Stribiżew
    Nov 22 '18 at 10:16














1












1








1








An example: prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000



I still need value till prod2-03_dl-httpd-prod
So basically we need value till second occurrence of '-' and number.



We tried following options:- 



echo "prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000" | sed -r 's/([^-][:digit:]+[^-][:digit:]).*/1/'





regex unix







share|improve this question
















An example: prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000



I still need value till prod2-03_dl-httpd-prod
So basically we need value till second occurrence of '-' and number.



We tried following options:- 



echo "prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000" | sed -r 's/([^-][:digit:]+[^-][:digit:]).*/1/'





regex unix




regex unix






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 22 '18 at 9:20









tukan

5,5641828




5,5641828










asked Nov 22 '18 at 9:18









Prashant RanePrashant Rane

134




134













  • You should probably read this: stackoverflow.com/help/someone-answers

    – James Brown
    Nov 22 '18 at 9:42











  • See my awk approach, it might turn out more robust that grep here.

    – Wiktor Stribiżew
    Nov 22 '18 at 10:16



















  • You should probably read this: stackoverflow.com/help/someone-answers

    – James Brown
    Nov 22 '18 at 9:42











  • See my awk approach, it might turn out more robust that grep here.

    – Wiktor Stribiżew
    Nov 22 '18 at 10:16

















You should probably read this: stackoverflow.com/help/someone-answers

– James Brown
Nov 22 '18 at 9:42





You should probably read this: stackoverflow.com/help/someone-answers

– James Brown
Nov 22 '18 at 9:42













See my awk approach, it might turn out more robust that grep here.

– Wiktor Stribiżew
Nov 22 '18 at 10:16





See my awk approach, it might turn out more robust that grep here.

– Wiktor Stribiżew
Nov 22 '18 at 10:16












2 Answers
2






active

oldest

votes


















2














Using pcregrep and positive lookahead:



$ echo "prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000" | 

  grep -Po "^[^-]*-.*?(?=-[0-9])"

prod2-03_dl-httpd-prod


Explained some:





  • grep -P: using PCRE


  • ^ from the beginning of the string


  • [^-]* all non-dashes


  • - followed by a dash


  • .*? followed by anything non-greedily


  • (?=-[0-9]) positive lookahead for a dash and a number






share|improve this answer


























  • Thanks James, Need one more help - can you please tell how get 8080 from same string.

    – Prashant Rane
    Nov 22 '18 at 9:59











  • Be more specific on the requirement, please. grep -o 8080 file otherwise. ;D

    – James Brown
    Nov 22 '18 at 16:02





















0














It seems the string can be parsed as a delimited string, use awk:



s="prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000"

awk -F'-' '{print $1 "-" $2 "-" $3}' <<< "$s"

# => prod2-03_dl-httpd

awk -F'-' '{sub(/_.*/, "", $5); print $5}' <<< "$s"

# => 8080

awk -F'[-_]' '{print $6}' <<< "$s"

# => 8080


See online awk demo



Here,





  • -F'-' sets field separator to -


  • {print $1 "-" $2 "-" $3} prints Fields from 1 to 3 with the separator chars in between


  • sub(/_.*/, "", $5) removes all text beginning with the first _ in Field 5 and then prints it

  • If the number of - and _ is constant before 8080, [-_] separator can be used and then {print $6} is enough.






share|improve this answer























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    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: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    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%2fstackoverflow.com%2fquestions%2f53427468%2fhow-to-get-a-string-untill-second-occurence-of-and-number%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









    2














    Using pcregrep and positive lookahead:



    $ echo "prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000" | 
    
  grep -Po "^[^-]*-.*?(?=-[0-9])"
    
prod2-03_dl-httpd-prod


    Explained some:





    • grep -P: using PCRE


    • ^ from the beginning of the string


    • [^-]* all non-dashes


    • - followed by a dash


    • .*? followed by anything non-greedily


    • (?=-[0-9]) positive lookahead for a dash and a number






    share|improve this answer


























    • Thanks James, Need one more help - can you please tell how get 8080 from same string.

      – Prashant Rane
      Nov 22 '18 at 9:59











    • Be more specific on the requirement, please. grep -o 8080 file otherwise. ;D

      – James Brown
      Nov 22 '18 at 16:02


















    2














    Using pcregrep and positive lookahead:



    $ echo "prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000" | 
    
  grep -Po "^[^-]*-.*?(?=-[0-9])"
    
prod2-03_dl-httpd-prod


    Explained some:





    • grep -P: using PCRE


    • ^ from the beginning of the string


    • [^-]* all non-dashes


    • - followed by a dash


    • .*? followed by anything non-greedily


    • (?=-[0-9]) positive lookahead for a dash and a number






    share|improve this answer


























    • Thanks James, Need one more help - can you please tell how get 8080 from same string.

      – Prashant Rane
      Nov 22 '18 at 9:59











    • Be more specific on the requirement, please. grep -o 8080 file otherwise. ;D

      – James Brown
      Nov 22 '18 at 16:02
















    2












    2








    2







    Using pcregrep and positive lookahead:



    $ echo "prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000" | 
    
  grep -Po "^[^-]*-.*?(?=-[0-9])"
    
prod2-03_dl-httpd-prod


    Explained some:





    • grep -P: using PCRE


    • ^ from the beginning of the string


    • [^-]* all non-dashes


    • - followed by a dash


    • .*? followed by anything non-greedily


    • (?=-[0-9]) positive lookahead for a dash and a number






    share|improve this answer















    Using pcregrep and positive lookahead:



    $ echo "prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000" | 
    
  grep -Po "^[^-]*-.*?(?=-[0-9])"
    
prod2-03_dl-httpd-prod


    Explained some:





    • grep -P: using PCRE


    • ^ from the beginning of the string


    • [^-]* all non-dashes


    • - followed by a dash


    • .*? followed by anything non-greedily


    • (?=-[0-9]) positive lookahead for a dash and a number







    share|improve this answer














    share|improve this answer



    share|improve this answer








    edited Nov 22 '18 at 9:38

























    answered Nov 22 '18 at 9:32









    James BrownJames Brown

    18.4k31635




    18.4k31635













    • Thanks James, Need one more help - can you please tell how get 8080 from same string.

      – Prashant Rane
      Nov 22 '18 at 9:59











    • Be more specific on the requirement, please. grep -o 8080 file otherwise. ;D

      – James Brown
      Nov 22 '18 at 16:02





















    • Thanks James, Need one more help - can you please tell how get 8080 from same string.

      – Prashant Rane
      Nov 22 '18 at 9:59











    • Be more specific on the requirement, please. grep -o 8080 file otherwise. ;D

      – James Brown
      Nov 22 '18 at 16:02



















    Thanks James, Need one more help - can you please tell how get 8080 from same string.

    – Prashant Rane
    Nov 22 '18 at 9:59





    Thanks James, Need one more help - can you please tell how get 8080 from same string.

    – Prashant Rane
    Nov 22 '18 at 9:59













    Be more specific on the requirement, please. grep -o 8080 file otherwise. ;D

    – James Brown
    Nov 22 '18 at 16:02







    Be more specific on the requirement, please. grep -o 8080 file otherwise. ;D

    – James Brown
    Nov 22 '18 at 16:02















    0














    It seems the string can be parsed as a delimited string, use awk:



    s="prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000"
    
awk -F'-' '{print $1 "-" $2 "-" $3}' <<< "$s"
    
# => prod2-03_dl-httpd
    
awk -F'-' '{sub(/_.*/, "", $5); print $5}' <<< "$s"
    
# => 8080
    
awk -F'[-_]' '{print $6}' <<< "$s"
    
# => 8080


    See online awk demo



    Here,





    • -F'-' sets field separator to -


    • {print $1 "-" $2 "-" $3} prints Fields from 1 to 3 with the separator chars in between


    • sub(/_.*/, "", $5) removes all text beginning with the first _ in Field 5 and then prints it

    • If the number of - and _ is constant before 8080, [-_] separator can be used and then {print $6} is enough.






    share|improve this answer




























      0














      It seems the string can be parsed as a delimited string, use awk:



      s="prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000"
      
awk -F'-' '{print $1 "-" $2 "-" $3}' <<< "$s"
      
# => prod2-03_dl-httpd
      
awk -F'-' '{sub(/_.*/, "", $5); print $5}' <<< "$s"
      
# => 8080
      
awk -F'[-_]' '{print $6}' <<< "$s"
      
# => 8080


      See online awk demo



      Here,





      • -F'-' sets field separator to -


      • {print $1 "-" $2 "-" $3} prints Fields from 1 to 3 with the separator chars in between


      • sub(/_.*/, "", $5) removes all text beginning with the first _ in Field 5 and then prints it

      • If the number of - and _ is constant before 8080, [-_] separator can be used and then {print $6} is enough.






      share|improve this answer


























        0












        0








        0







        It seems the string can be parsed as a delimited string, use awk:



        s="prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000"
        
awk -F'-' '{print $1 "-" $2 "-" $3}' <<< "$s"
        
# => prod2-03_dl-httpd
        
awk -F'-' '{sub(/_.*/, "", $5); print $5}' <<< "$s"
        
# => 8080
        
awk -F'[-_]' '{print $6}' <<< "$s"
        
# => 8080


        See online awk demo



        Here,





        • -F'-' sets field separator to -


        • {print $1 "-" $2 "-" $3} prints Fields from 1 to 3 with the separator chars in between


        • sub(/_.*/, "", $5) removes all text beginning with the first _ in Field 5 and then prints it

        • If the number of - and _ is constant before 8080, [-_] separator can be used and then {print $6} is enough.






        share|improve this answer













        It seems the string can be parsed as a delimited string, use awk:



        s="prod2-03_dl-httpd-prod-8080_access_referer_log.20181111-050000"
        
awk -F'-' '{print $1 "-" $2 "-" $3}' <<< "$s"
        
# => prod2-03_dl-httpd
        
awk -F'-' '{sub(/_.*/, "", $5); print $5}' <<< "$s"
        
# => 8080
        
awk -F'[-_]' '{print $6}' <<< "$s"
        
# => 8080


        See online awk demo



        Here,





        • -F'-' sets field separator to -


        • {print $1 "-" $2 "-" $3} prints Fields from 1 to 3 with the separator chars in between


        • sub(/_.*/, "", $5) removes all text beginning with the first _ in Field 5 and then prints it

        • If the number of - and _ is constant before 8080, [-_] separator can be used and then {print $6} is enough.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 22 '18 at 10:13









        Wiktor StribiżewWiktor Stribiżew

        313k16133207




        313k16133207






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • 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%2fstackoverflow.com%2fquestions%2f53427468%2fhow-to-get-a-string-untill-second-occurence-of-and-number%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

            Costa Masnaga

            Image
            .mw-parser-output .avviso .mbox-text-div>div,.mw-parser-output .avviso .mbox-text-full-div>div{font-size:90%}.mw-parser-output .avviso .mbox-image div{width:52px}.mw-parser-output .avviso .mbox-text-full-div .hide-when-compact{display:block} Questa voce o sezione sull'argomento Lombardia non cita le fonti necessarie o quelle presenti sono insufficienti . Puoi migliorare questa voce aggiungendo citazioni da fonti attendibili secondo le linee guida sull'uso delle fonti. Segui i suggerimenti del progetto di riferimento. Costa Masnaga comune Localizzazione Stato   Italia Regione Lombardia Provincia Lecco Amministrazione Sindaco Sabina Panzeri (Al centro il cittadino) dall'08/06/2009 Territorio Coordinate 45°46′N 9°17′E  /  45.766667°N 9.283333°E 45.766667; 9.283333  ( Costa Masnaga ) Coordinate: 45°46′N 9°17′E  /  45.766667°N 9.283333°E 45.766667; 9.283333  ( Costa Masnaga ) Altitudine 318 m s.l.m...
            Read more

            Fotorealismo

            Image
            Guerrino Boatto, Venice's St. Barnaba Church and canal Il fotorealismo è un genere di pittura basato sull'uso di una o più fotografie dalle quali l'artista prende le informazioni necessarie da utilizzare poi nel processo della creazione dell'opera, in genere ad olio o ad acrilico, al fine di avere un aspetto finale il più simile possibile alla fotografia. Indice 1 Storia 2 Lista dei fotorealisti 3 Note 4 Voci correlate 5 Altri progetti Storia | Il fotorealismo è un movimento che nasce negli Stati Uniti d'America alla fine degli anni sessanta [1] sulla scia della Pop Art [2] [3] [4] , e insieme condividono il carattere reazionario verso la travolgente ascesa dei media, che alla metà del ventesimo secolo si trasforma in un fenomeno di massa talmente imponente da minacciare il valore dell'immagine nell'arte. [5] [6] Ne consegue così che, colto il gesto d'inizio che fu della Pop Art, i fotorealisti aprono ad un ...
            Read more

            Sidney Franklin

            Image
            Questa voce sull'argomento registi statunitensi è solo un abbozzo . Contribuisci a migliorarla secondo le convenzioni di Wikipedia. Sidney Franklin, foto di Carl Van Vechten Oscar alla memoria Irving G. Thalberg 1943 Sidney Franklin , all'anagrafe Sidney Arnold Franklin , (San Francisco, 21 marzo 1893 – Santa Monica, 18 maggio 1972), è stato un regista, produttore cinematografico e attore statunitense. Il 20 giugno 1963, si sposò con l'attrice australiana Enid Bennett. Il matrimonio durò fino alla morte dell'attrice, il 14 maggio 1969 [1] Indice 1 Filmografia 1.1 Regista 1.2 Aiuto regia (parziale) 1.3 Produttore 1.4 Attore (parziale) 2 Note 3 Altri progetti 4 Collegamenti esterni Filmografia | Regista | The Baby , co-regia Chester M. Franklin (1915) The Rivals , co-regia Chester M. Franklin (1915) Little Dick's First Case , co-regia Chester M. Franklin (1915) Her Filmland Hero , co-...
            Read more