Extract Data From Second Line of OutputSave PL/pgSQL output from PostgreSQL to a CSV fileHow to import CSV file data into a PostgreSQL table?How to exit from PostgreSQL command line utility: psqlRun a PostgreSQL .sql file using command line argumentsPostgres psql output strings without escape charactersHow to save numpy array of Strings (with commas) to CSV?Replace contents of regexp_matchesUnquoted carriage return found in data - Preventing COPY FROM in PostgreSQLConvert query result to JSONExtracting field from multiline text that is piped into Perl

How to play a D major chord lower than the open E major chord on guitar?

PhD: When to quit and move on?

Is it bad to suddenly introduce another element to your fantasy world a good ways into the story?

What do I need to see before Spider-Man: Far From Home?

Convert integer to full text string duration

Check whether quotient ring is a field or an integral domain

2000s (or earlier) cyberpunk novel: dystopia, mega storm, omnipresent noise

Taking advantage when the HR forgets to communicate the rules

How would a sea turtle end up on its back?

How can select a specific triangle in my Delaunay mesh?

Can a USB hub be used to access a drive from 2 devices?

Why do we need a bootloader separate from our application program in microcontrollers?

Should I increase my 401(k) contributions, or increase my mortgage payments

Advice for making/keeping shredded chicken moist?

How did Captain Marvel do this without dying?

Did Stalin kill all Soviet officers involved in the Winter War?

Do Goblin tokens count as Goblins?

Why do most airliners have underwing engines, while business jets have rear-mounted engines?

Can you take the Dodge action while prone?

Is there a standard definition of the "stall" phenomena?

Why isn't addition defined this way?

Initializing variables variable in an "if" statement

Taking my Ph.D. advisor out for dinner after graduation

How frequently do Russian people still refer to others by their patronymic (отчество)?



Extract Data From Second Line of Output


Save PL/pgSQL output from PostgreSQL to a CSV fileHow to import CSV file data into a PostgreSQL table?How to exit from PostgreSQL command line utility: psqlRun a PostgreSQL .sql file using command line argumentsPostgres psql output strings without escape charactersHow to save numpy array of Strings (with commas) to CSV?Replace contents of regexp_matchesUnquoted carriage return found in data - Preventing COPY FROM in PostgreSQLConvert query result to JSONExtracting field from multiline text that is piped into Perl






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








0















I have a table that contains message_content. It looks like this:



message_content | WFUS54 ABNT 080344rr
| TORLCHrr
| TXC245-361-080415-r


How would I extract only the 2nd line of that output(TORLCH)? I've tried to shorten the output to a certain number of characters but that ultimately doesn't provide what I want. I've also tried removing carriage returns and new lines. I am outputting my results to a CSV I could manipulate with Python, but was wondering if there's a way to do it in the query first.



Based on other examples, it seems like I could use a regular expression to maybe do this? Not sure where to start with learning that though.










share|improve this question




























    0















    I have a table that contains message_content. It looks like this:



    message_content | WFUS54 ABNT 080344rr
    | TORLCHrr
    | TXC245-361-080415-r


    How would I extract only the 2nd line of that output(TORLCH)? I've tried to shorten the output to a certain number of characters but that ultimately doesn't provide what I want. I've also tried removing carriage returns and new lines. I am outputting my results to a CSV I could manipulate with Python, but was wondering if there's a way to do it in the query first.



    Based on other examples, it seems like I could use a regular expression to maybe do this? Not sure where to start with learning that though.










    share|improve this question
























      0












      0








      0








      I have a table that contains message_content. It looks like this:



      message_content | WFUS54 ABNT 080344rr
      | TORLCHrr
      | TXC245-361-080415-r


      How would I extract only the 2nd line of that output(TORLCH)? I've tried to shorten the output to a certain number of characters but that ultimately doesn't provide what I want. I've also tried removing carriage returns and new lines. I am outputting my results to a CSV I could manipulate with Python, but was wondering if there's a way to do it in the query first.



      Based on other examples, it seems like I could use a regular expression to maybe do this? Not sure where to start with learning that though.










      share|improve this question














      I have a table that contains message_content. It looks like this:



      message_content | WFUS54 ABNT 080344rr
      | TORLCHrr
      | TXC245-361-080415-r


      How would I extract only the 2nd line of that output(TORLCH)? I've tried to shorten the output to a certain number of characters but that ultimately doesn't provide what I want. I've also tried removing carriage returns and new lines. I am outputting my results to a CSV I could manipulate with Python, but was wondering if there's a way to do it in the query first.



      Based on other examples, it seems like I could use a regular expression to maybe do this? Not sure where to start with learning that though.







      postgresql postgresql-9.5






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 25 at 20:00









      klex52sklex52s

      1459 bronze badges




      1459 bronze badges






















          1 Answer
          1






          active

          oldest

          votes


















          0














          you can split the line into an array, then take the second element:



          (string_to_array(message_content, e'rr'))[2]


          Online example: https://rextester.com/MDYLXB40812






          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%2f55345542%2fextract-data-from-second-line-of-output%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            you can split the line into an array, then take the second element:



            (string_to_array(message_content, e'rr'))[2]


            Online example: https://rextester.com/MDYLXB40812






            share|improve this answer



























              0














              you can split the line into an array, then take the second element:



              (string_to_array(message_content, e'rr'))[2]


              Online example: https://rextester.com/MDYLXB40812






              share|improve this answer

























                0












                0








                0







                you can split the line into an array, then take the second element:



                (string_to_array(message_content, e'rr'))[2]


                Online example: https://rextester.com/MDYLXB40812






                share|improve this answer













                you can split the line into an array, then take the second element:



                (string_to_array(message_content, e'rr'))[2]


                Online example: https://rextester.com/MDYLXB40812







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Mar 25 at 20:12









                a_horse_with_no_namea_horse_with_no_name

                320k50 gold badges494 silver badges596 bronze badges




                320k50 gold badges494 silver badges596 bronze badges


















                    Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.







                    Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.



















                    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%2f55345542%2fextract-data-from-second-line-of-output%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

                    Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

                    SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

                    은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현