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;








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?










share|improve this question






















  • "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

















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?










share|improve this question






















  • "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













0












0








0


1






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?










share|improve this question














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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










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

















  • "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










2 Answers
2






active

oldest

votes


















1














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 '^$'





share|improve this answer























  • 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











  • 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



















1














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 ).






share|improve this answer

























  • 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











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
);



);













draft saved

draft discarded


















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









1














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 '^$'





share|improve this answer























  • 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











  • 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
















1














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 '^$'





share|improve this answer























  • 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











  • 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














1












1








1







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 '^$'





share|improve this answer













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 '^$'






share|improve this answer












share|improve this answer



share|improve this answer










answered Apr 7 '15 at 8:21









FloHimselfFloHimself

6,71421419




6,71421419












  • 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











  • 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 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











  • 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 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














1














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 ).






share|improve this answer

























  • 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















1














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 ).






share|improve this answer

























  • 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













1












1








1







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 ).






share|improve this answer















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 ).







share|improve this answer














share|improve this answer



share|improve this answer








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 use awk 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











  • @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
















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

















draft saved

draft discarded
















































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%2f194756%2fawk-one-liner-to-print-column-of-sql-table%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, sql

Popular posts from this blog

Frič See also Navigation menuinternal link

Identify plant with long narrow paired leaves and reddish stems Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?What is this plant with long sharp leaves? Is it a weed?What is this 3ft high, stalky plant, with mid sized narrow leaves?What is this young shrub with opposite ovate, crenate leaves and reddish stems?What is this plant with large broad serrated leaves?Identify this upright branching weed with long leaves and reddish stemsPlease help me identify this bulbous plant with long, broad leaves and white flowersWhat is this small annual with narrow gray/green leaves and rust colored daisy-type flowers?What is this chilli plant?Does anyone know what type of chilli plant this is?Help identify this plant

fontconfig warning: “/etc/fonts/fonts.conf”, line 100: unknown “element blank” The 2019 Stack Overflow Developer Survey Results Are In“tar: unrecognized option --warning” during 'apt-get install'How to fix Fontconfig errorHow do I figure out which font file is chosen for a system generic font alias?Why are some apt-get-installed fonts being ignored by fc-list, xfontsel, etc?Reload settings in /etc/fonts/conf.dTaking 30 seconds longer to boot after upgrade from jessie to stretchHow to match multiple font names with a single <match> element?Adding a custom font to fontconfigRemoving fonts from fontconfig <match> resultsBroken fonts after upgrading Firefox ESR to latest Firefox