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;
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
add a comment |
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
add a comment |
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
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
postgresql postgresql-9.5
asked Mar 25 at 20:00
klex52sklex52s
1459 bronze badges
1459 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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
add a comment |
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
add a comment |
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
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
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
add a comment |
add a comment |
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.
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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