Awk one-liner to print column of SQL table? 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 Results Why I closed the “Why is Kali so hard” questionSearch for a Value only in one column w.o using awk, sed, or perlsplitting a column using awksubstituting a column value using awkCompare two sql output files which have column names and print the difference into another fileHow to print first column of next line in current line?How to print a specific column condition using awk?Print column with AWKusing awk to print lines from one match through a second instance of a separate matchAWK - print last column along with empty valuecompare column of two files and print data accordingly
English words in a non-english sci-fi novel
Generate an RGB colour grid
Ring Automorphisms that fix 1.
Dating a Former Employee
How do I keep my slimes from escaping their pens?
How do pianists reach extremely loud dynamics?
What's the meaning of 間時肆拾貳 at a car parking sign
In predicate logic, does existential quantification (∃) include universal quantification (∀), i.e. can 'some' imply 'all'?
How to deal with a team lead who never gives me credit?
What's the purpose of writing one's academic biography in the third person?
If a contract sometimes uses the wrong name, is it still valid?
When were vectors invented?
Why is "Consequences inflicted." not a sentence?
What is the logic behind the Maharil's explanation of why we don't say שעשה ניסים on Pesach?
How much time will it take to get my passport back if I am applying for multiple Schengen visa countries?
How discoverable are IPv6 addresses and AAAA names by potential attackers?
How to align text above triangle figure
porting install scripts : can rpm replace apt?
How to bypass password on Windows XP account?
What is Wonderstone and are there any references to it pre-1982?
Identifying polygons that intersect with another layer using QGIS?
How do I stop a creek from eroding my steep embankment?
Why am I getting the error "non-boolean type specified in a context where a condition is expected" for this request?
How to react to hostile behavior from a senior developer?
Awk one-liner to print column of SQL table?
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 Results
Why I closed the “Why is Kali so hard” questionSearch for a Value only in one column w.o using awk, sed, or perlsplitting a column using awksubstituting a column value using awkCompare two sql output files which have column names and print the difference into another fileHow to print first column of next line in current line?How to print a specific column condition using awk?Print column with AWKusing awk to print lines from one match through a second instance of a separate matchAWK - print last column along with empty valuecompare column of two files and print data accordingly
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Suppose I have table like:
This is first line
name minimum maximum config_value
----------------------------------- ----------- ----------- ------------
some text goes here for sample 0 1 0
Output Ends
The out should be like column 2nd:
minimum
-----------
0
What will be the awk command to generate the output like this?
linux awk sql
add a comment |
Suppose I have table like:
This is first line
name minimum maximum config_value
----------------------------------- ----------- ----------- ------------
some text goes here for sample 0 1 0
Output Ends
The out should be like column 2nd:
minimum
-----------
0
What will be the awk command to generate the output like this?
linux awk sql
"This is first line" and "Output Ends" are in the table?
– yeti
Apr 7 '15 at 7:59
"This is first line" and "Output Ends" should not be visible in output.
– snoop
Apr 7 '15 at 8:07
add a comment |
Suppose I have table like:
This is first line
name minimum maximum config_value
----------------------------------- ----------- ----------- ------------
some text goes here for sample 0 1 0
Output Ends
The out should be like column 2nd:
minimum
-----------
0
What will be the awk command to generate the output like this?
linux awk sql
Suppose I have table like:
This is first line
name minimum maximum config_value
----------------------------------- ----------- ----------- ------------
some text goes here for sample 0 1 0
Output Ends
The out should be like column 2nd:
minimum
-----------
0
What will be the awk command to generate the output like this?
linux awk sql
linux awk sql
asked Apr 7 '15 at 7:12
snoopsnoop
224110
224110
"This is first line" and "Output Ends" are in the table?
– yeti
Apr 7 '15 at 7:59
"This is first line" and "Output Ends" should not be visible in output.
– snoop
Apr 7 '15 at 8:07
add a comment |
"This is first line" and "Output Ends" are in the table?
– yeti
Apr 7 '15 at 7:59
"This is first line" and "Output Ends" should not be visible in output.
– snoop
Apr 7 '15 at 8:07
"This is first line" and "Output Ends" are in the table?
– yeti
Apr 7 '15 at 7:59
"This is first line" and "Output Ends" are in the table?
– yeti
Apr 7 '15 at 7:59
"This is first line" and "Output Ends" should not be visible in output.
– snoop
Apr 7 '15 at 8:07
"This is first line" and "Output Ends" should not be visible in output.
– snoop
Apr 7 '15 at 8:07
add a comment |
2 Answers
2
active
oldest
votes
If awk
is not an substantial requirement, you could cut
the file in pieces on fixed bytes (and grep
away empty lines):
cut -b 37-47 data | grep -v '^$'
andgrep
away those first and last marker lines
– Skaperen
Apr 7 '15 at 8:27
Be careful that length of first column may vary depending on the "name" value.
– apaul
Apr 7 '15 at 8:30
And start byte and length might vary. Well, this is more an example for usingcut
to achieve what OP is asking for, based on the information the question offers, than an final solution.
– FloHimself
Apr 7 '15 at 8:34
add a comment |
I'm no awk guru, but if your output is always the same (I mean, second line is headers, and third line contains results), you can use something like this:
cat /tmp/test.txt | awk 'NR==2 headers=$0; start=0; len=0 NR==3 start=index($0," "); len=length($2)+1; print substr(headers,start,len) ; print substr($0,start,len) NR==4 print substr($0,start,len)'
Since it's length delimited fields, you can get the starting index and length of your field by reading the "underline" line (NR==3
).
If your SQL returns more than one line, so you'd have to use something like if( NR > 1 && NR <= x )
.
Can we have an example which does not contain , in awk command? as I have to write this command in csv file.
– snoop
Apr 7 '15 at 8:14
@snoop : sorry, I'm not able to make it without comma. Can't you define another field separator for your CSV file? Otherway, are you really required to useawk
only as @FloHimself specified?
– apaul
Apr 7 '15 at 9:24
add a comment |
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
);
);
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%2funix.stackexchange.com%2fquestions%2f194756%2fawk-one-liner-to-print-column-of-sql-table%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
If awk
is not an substantial requirement, you could cut
the file in pieces on fixed bytes (and grep
away empty lines):
cut -b 37-47 data | grep -v '^$'
andgrep
away those first and last marker lines
– Skaperen
Apr 7 '15 at 8:27
Be careful that length of first column may vary depending on the "name" value.
– apaul
Apr 7 '15 at 8:30
And start byte and length might vary. Well, this is more an example for usingcut
to achieve what OP is asking for, based on the information the question offers, than an final solution.
– FloHimself
Apr 7 '15 at 8:34
add a comment |
If awk
is not an substantial requirement, you could cut
the file in pieces on fixed bytes (and grep
away empty lines):
cut -b 37-47 data | grep -v '^$'
andgrep
away those first and last marker lines
– Skaperen
Apr 7 '15 at 8:27
Be careful that length of first column may vary depending on the "name" value.
– apaul
Apr 7 '15 at 8:30
And start byte and length might vary. Well, this is more an example for usingcut
to achieve what OP is asking for, based on the information the question offers, than an final solution.
– FloHimself
Apr 7 '15 at 8:34
add a comment |
If awk
is not an substantial requirement, you could cut
the file in pieces on fixed bytes (and grep
away empty lines):
cut -b 37-47 data | grep -v '^$'
If awk
is not an substantial requirement, you could cut
the file in pieces on fixed bytes (and grep
away empty lines):
cut -b 37-47 data | grep -v '^$'
answered Apr 7 '15 at 8:21
FloHimselfFloHimself
6,71421419
6,71421419
andgrep
away those first and last marker lines
– Skaperen
Apr 7 '15 at 8:27
Be careful that length of first column may vary depending on the "name" value.
– apaul
Apr 7 '15 at 8:30
And start byte and length might vary. Well, this is more an example for usingcut
to achieve what OP is asking for, based on the information the question offers, than an final solution.
– FloHimself
Apr 7 '15 at 8:34
add a comment |
andgrep
away those first and last marker lines
– Skaperen
Apr 7 '15 at 8:27
Be careful that length of first column may vary depending on the "name" value.
– apaul
Apr 7 '15 at 8:30
And start byte and length might vary. Well, this is more an example for usingcut
to achieve what OP is asking for, based on the information the question offers, than an final solution.
– FloHimself
Apr 7 '15 at 8:34
and
grep
away those first and last marker lines– Skaperen
Apr 7 '15 at 8:27
and
grep
away those first and last marker lines– Skaperen
Apr 7 '15 at 8:27
Be careful that length of first column may vary depending on the "name" value.
– apaul
Apr 7 '15 at 8:30
Be careful that length of first column may vary depending on the "name" value.
– apaul
Apr 7 '15 at 8:30
And start byte and length might vary. Well, this is more an example for using
cut
to achieve what OP is asking for, based on the information the question offers, than an final solution.– FloHimself
Apr 7 '15 at 8:34
And start byte and length might vary. Well, this is more an example for using
cut
to achieve what OP is asking for, based on the information the question offers, than an final solution.– FloHimself
Apr 7 '15 at 8:34
add a comment |
I'm no awk guru, but if your output is always the same (I mean, second line is headers, and third line contains results), you can use something like this:
cat /tmp/test.txt | awk 'NR==2 headers=$0; start=0; len=0 NR==3 start=index($0," "); len=length($2)+1; print substr(headers,start,len) ; print substr($0,start,len) NR==4 print substr($0,start,len)'
Since it's length delimited fields, you can get the starting index and length of your field by reading the "underline" line (NR==3
).
If your SQL returns more than one line, so you'd have to use something like if( NR > 1 && NR <= x )
.
Can we have an example which does not contain , in awk command? as I have to write this command in csv file.
– snoop
Apr 7 '15 at 8:14
@snoop : sorry, I'm not able to make it without comma. Can't you define another field separator for your CSV file? Otherway, are you really required to useawk
only as @FloHimself specified?
– apaul
Apr 7 '15 at 9:24
add a comment |
I'm no awk guru, but if your output is always the same (I mean, second line is headers, and third line contains results), you can use something like this:
cat /tmp/test.txt | awk 'NR==2 headers=$0; start=0; len=0 NR==3 start=index($0," "); len=length($2)+1; print substr(headers,start,len) ; print substr($0,start,len) NR==4 print substr($0,start,len)'
Since it's length delimited fields, you can get the starting index and length of your field by reading the "underline" line (NR==3
).
If your SQL returns more than one line, so you'd have to use something like if( NR > 1 && NR <= x )
.
Can we have an example which does not contain , in awk command? as I have to write this command in csv file.
– snoop
Apr 7 '15 at 8:14
@snoop : sorry, I'm not able to make it without comma. Can't you define another field separator for your CSV file? Otherway, are you really required to useawk
only as @FloHimself specified?
– apaul
Apr 7 '15 at 9:24
add a comment |
I'm no awk guru, but if your output is always the same (I mean, second line is headers, and third line contains results), you can use something like this:
cat /tmp/test.txt | awk 'NR==2 headers=$0; start=0; len=0 NR==3 start=index($0," "); len=length($2)+1; print substr(headers,start,len) ; print substr($0,start,len) NR==4 print substr($0,start,len)'
Since it's length delimited fields, you can get the starting index and length of your field by reading the "underline" line (NR==3
).
If your SQL returns more than one line, so you'd have to use something like if( NR > 1 && NR <= x )
.
I'm no awk guru, but if your output is always the same (I mean, second line is headers, and third line contains results), you can use something like this:
cat /tmp/test.txt | awk 'NR==2 headers=$0; start=0; len=0 NR==3 start=index($0," "); len=length($2)+1; print substr(headers,start,len) ; print substr($0,start,len) NR==4 print substr($0,start,len)'
Since it's length delimited fields, you can get the starting index and length of your field by reading the "underline" line (NR==3
).
If your SQL returns more than one line, so you'd have to use something like if( NR > 1 && NR <= x )
.
edited 11 hours ago
Rui F Ribeiro
42.1k1484142
42.1k1484142
answered Apr 7 '15 at 8:05
apaulapaul
2,5101913
2,5101913
Can we have an example which does not contain , in awk command? as I have to write this command in csv file.
– snoop
Apr 7 '15 at 8:14
@snoop : sorry, I'm not able to make it without comma. Can't you define another field separator for your CSV file? Otherway, are you really required to useawk
only as @FloHimself specified?
– apaul
Apr 7 '15 at 9:24
add a comment |
Can we have an example which does not contain , in awk command? as I have to write this command in csv file.
– snoop
Apr 7 '15 at 8:14
@snoop : sorry, I'm not able to make it without comma. Can't you define another field separator for your CSV file? Otherway, are you really required to useawk
only as @FloHimself specified?
– apaul
Apr 7 '15 at 9:24
Can we have an example which does not contain , in awk command? as I have to write this command in csv file.
– snoop
Apr 7 '15 at 8:14
Can we have an example which does not contain , in awk command? as I have to write this command in csv file.
– snoop
Apr 7 '15 at 8:14
@snoop : sorry, I'm not able to make it without comma. Can't you define another field separator for your CSV file? Otherway, are you really required to use
awk
only as @FloHimself specified?– apaul
Apr 7 '15 at 9:24
@snoop : sorry, I'm not able to make it without comma. Can't you define another field separator for your CSV file? Otherway, are you really required to use
awk
only as @FloHimself specified?– apaul
Apr 7 '15 at 9:24
add a comment |
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.
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%2funix.stackexchange.com%2fquestions%2f194756%2fawk-one-liner-to-print-column-of-sql-table%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
-awk, linux, sql
"This is first line" and "Output Ends" are in the table?
– yeti
Apr 7 '15 at 7:59
"This is first line" and "Output Ends" should not be visible in output.
– snoop
Apr 7 '15 at 8:07