Print a column without 1st item of that column
Good night everybody, i want to print a column without printing the 1st item of that column.
I want print the 4th column of this csv file:
ID;Curso;AnoNasc;MediaAcesso;Salario;IndiceSatisfacao
1;Psicologia;1994;18;750;3
2;Psicologia;1992;17;754;4
3;Psicologia;1991;13;780;4
4;Psicologia;1993;11;900;4
So i do this:
system("awk -F ';' '{print $4}' DBcursos.csv > ficha02exer08-mediaacesso.dat");
But this print:
MediaAcesso
18
17
13
11
But i only want the numbers, so i want to print all except the first line (MediaAcesso), how can i do this? Can i do this with AWK?
Thank you!
linux awk
add a comment |
Good night everybody, i want to print a column without printing the 1st item of that column.
I want print the 4th column of this csv file:
ID;Curso;AnoNasc;MediaAcesso;Salario;IndiceSatisfacao
1;Psicologia;1994;18;750;3
2;Psicologia;1992;17;754;4
3;Psicologia;1991;13;780;4
4;Psicologia;1993;11;900;4
So i do this:
system("awk -F ';' '{print $4}' DBcursos.csv > ficha02exer08-mediaacesso.dat");
But this print:
MediaAcesso
18
17
13
11
But i only want the numbers, so i want to print all except the first line (MediaAcesso), how can i do this? Can i do this with AWK?
Thank you!
linux awk
Exactly, i want print the 4th column without 1st element of that column, in this case without "MediaAcesso"
– José Miranda
Nov 14 '18 at 20:14
Yeah, now i know that... I just started using awk today, so i'm kind a noobie with this.
– José Miranda
Nov 14 '18 at 20:18
add a comment |
Good night everybody, i want to print a column without printing the 1st item of that column.
I want print the 4th column of this csv file:
ID;Curso;AnoNasc;MediaAcesso;Salario;IndiceSatisfacao
1;Psicologia;1994;18;750;3
2;Psicologia;1992;17;754;4
3;Psicologia;1991;13;780;4
4;Psicologia;1993;11;900;4
So i do this:
system("awk -F ';' '{print $4}' DBcursos.csv > ficha02exer08-mediaacesso.dat");
But this print:
MediaAcesso
18
17
13
11
But i only want the numbers, so i want to print all except the first line (MediaAcesso), how can i do this? Can i do this with AWK?
Thank you!
linux awk
Good night everybody, i want to print a column without printing the 1st item of that column.
I want print the 4th column of this csv file:
ID;Curso;AnoNasc;MediaAcesso;Salario;IndiceSatisfacao
1;Psicologia;1994;18;750;3
2;Psicologia;1992;17;754;4
3;Psicologia;1991;13;780;4
4;Psicologia;1993;11;900;4
So i do this:
system("awk -F ';' '{print $4}' DBcursos.csv > ficha02exer08-mediaacesso.dat");
But this print:
MediaAcesso
18
17
13
11
But i only want the numbers, so i want to print all except the first line (MediaAcesso), how can i do this? Can i do this with AWK?
Thank you!
linux awk
linux awk
edited Nov 14 '18 at 20:11
lurker
43.8k74572
43.8k74572
asked Nov 14 '18 at 20:07
José Miranda
63
63
Exactly, i want print the 4th column without 1st element of that column, in this case without "MediaAcesso"
– José Miranda
Nov 14 '18 at 20:14
Yeah, now i know that... I just started using awk today, so i'm kind a noobie with this.
– José Miranda
Nov 14 '18 at 20:18
add a comment |
Exactly, i want print the 4th column without 1st element of that column, in this case without "MediaAcesso"
– José Miranda
Nov 14 '18 at 20:14
Yeah, now i know that... I just started using awk today, so i'm kind a noobie with this.
– José Miranda
Nov 14 '18 at 20:18
Exactly, i want print the 4th column without 1st element of that column, in this case without "MediaAcesso"
– José Miranda
Nov 14 '18 at 20:14
Exactly, i want print the 4th column without 1st element of that column, in this case without "MediaAcesso"
– José Miranda
Nov 14 '18 at 20:14
Yeah, now i know that... I just started using awk today, so i'm kind a noobie with this.
– José Miranda
Nov 14 '18 at 20:18
Yeah, now i know that... I just started using awk today, so i'm kind a noobie with this.
– José Miranda
Nov 14 '18 at 20:18
add a comment |
1 Answer
1
active
oldest
votes
Don't think of it as skipping the first element of a column, you just want to skip processing the entire first row of the file. So check the record number and only process records after that one.
awk -F ';' 'NR > 1 {print $4}' DBcursos.csv > ficha02exer08-mediaacesso.dat
That's it!! Thank you so much.
– José Miranda
Nov 14 '18 at 20:17
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%2f53308013%2fprint-a-column-without-1st-item-of-that-column%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
Don't think of it as skipping the first element of a column, you just want to skip processing the entire first row of the file. So check the record number and only process records after that one.
awk -F ';' 'NR > 1 {print $4}' DBcursos.csv > ficha02exer08-mediaacesso.dat
That's it!! Thank you so much.
– José Miranda
Nov 14 '18 at 20:17
add a comment |
Don't think of it as skipping the first element of a column, you just want to skip processing the entire first row of the file. So check the record number and only process records after that one.
awk -F ';' 'NR > 1 {print $4}' DBcursos.csv > ficha02exer08-mediaacesso.dat
That's it!! Thank you so much.
– José Miranda
Nov 14 '18 at 20:17
add a comment |
Don't think of it as skipping the first element of a column, you just want to skip processing the entire first row of the file. So check the record number and only process records after that one.
awk -F ';' 'NR > 1 {print $4}' DBcursos.csv > ficha02exer08-mediaacesso.dat
Don't think of it as skipping the first element of a column, you just want to skip processing the entire first row of the file. So check the record number and only process records after that one.
awk -F ';' 'NR > 1 {print $4}' DBcursos.csv > ficha02exer08-mediaacesso.dat
edited Nov 14 '18 at 20:18
answered Nov 14 '18 at 20:15
Barmar
420k35244344
420k35244344
That's it!! Thank you so much.
– José Miranda
Nov 14 '18 at 20:17
add a comment |
That's it!! Thank you so much.
– José Miranda
Nov 14 '18 at 20:17
That's it!! Thank you so much.
– José Miranda
Nov 14 '18 at 20:17
That's it!! Thank you so much.
– José Miranda
Nov 14 '18 at 20:17
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53308013%2fprint-a-column-without-1st-item-of-that-column%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
Exactly, i want print the 4th column without 1st element of that column, in this case without "MediaAcesso"
– José Miranda
Nov 14 '18 at 20:14
Yeah, now i know that... I just started using awk today, so i'm kind a noobie with this.
– José Miranda
Nov 14 '18 at 20:18