Extract lines from a file with a value,whose parameter greater than 100, with grep and awk
I have a file, and I have to create a script with the following output file as per the specifications:
The input file has first 28 lines of header, which have to be included in the output
Some of the lines of the input have a specific parameter ZH:any value (eg ZH:100 or ZH:50). The column where the ZH parameter is present differs from line to line.
My output file should contain the header lines and those lines which contain the ZH parameter with corresponding values greater than 100 (eg ZH:105 , ZH:200 and so on)
The lines which do not contain the ZH parameter are to be omitted.
awk sed grep
edited 17 mins ago
Rui F Ribeiro
40.5k1479137
asked 18 mins ago
DavidDavid
11
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a file, and I have to create a script with the following output file as per the specifications:
The input file has first 28 lines of header, which have to be included in the output
Some of the lines of the input have a specific parameter ZH:any value (eg ZH:100 or ZH:50). The column where the ZH parameter is present differs from line to line.
My output file should contain the header lines and those lines which contain the ZH parameter with corresponding values greater than 100 (eg ZH:105 , ZH:200 and so on)
The lines which do not contain the ZH parameter are to be omitted.
awk sed grep
edited 17 mins ago
Rui F Ribeiro
40.5k1479137
asked 18 mins ago
DavidDavid
11
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please add samples of the output and input, tell us what was done until now and where you might enlighten you. This is a Unix questions site, not a script delivering service.
– Rui F Ribeiro
15 mins ago
It is not possible to show a sample file here as the files are very big themselves and the lines are too long to post in the comments section.
– David
6 mins ago
The file is a sam file, obtained by alignment to a genome
– David
6 mins ago
I have very little knowledge of linux, hence the question
– David
5 mins ago
@David Then cut the length of the line so that it's manageable, while still allowing someone to properly test a solution against it. You've said nothing about your file apart from that it has a header and fields.
– Kusalananda
11 secs ago
add a comment |
I have a file, and I have to create a script with the following output file as per the specifications:
The input file has first 28 lines of header, which have to be included in the output
Some of the lines of the input have a specific parameter ZH:any value (eg ZH:100 or ZH:50). The column where the ZH parameter is present differs from line to line.
My output file should contain the header lines and those lines which contain the ZH parameter with corresponding values greater than 100 (eg ZH:105 , ZH:200 and so on)
The lines which do not contain the ZH parameter are to be omitted.
awk sed grep
edited 17 mins ago
Rui F Ribeiro
40.5k1479137
asked 18 mins ago
DavidDavid
11
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a file, and I have to create a script with the following output file as per the specifications:
The input file has first 28 lines of header, which have to be included in the output
Some of the lines of the input have a specific parameter ZH:any value (eg ZH:100 or ZH:50). The column where the ZH parameter is present differs from line to line.
My output file should contain the header lines and those lines which contain the ZH parameter with corresponding values greater than 100 (eg ZH:105 , ZH:200 and so on)
The lines which do not contain the ZH parameter are to be omitted.
awk sed grep
awk sed grep
edited 17 mins ago
Rui F Ribeiro
40.5k1479137
asked 18 mins ago
DavidDavid
11
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 17 mins ago
Rui F Ribeiro
40.5k1479137
asked 18 mins ago
DavidDavid
11
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 17 mins ago
Rui F Ribeiro
40.5k1479137
edited 17 mins ago
Rui F Ribeiro
40.5k1479137
edited 17 mins ago
Rui F Ribeiro
40.5k1479137
40.5k1479137
asked 18 mins ago
DavidDavid
11
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 18 mins ago
DavidDavid
11
asked 18 mins ago
DavidDavid
11
11
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please add samples of the output and input, tell us what was done until now and where you might enlighten you. This is a Unix questions site, not a script delivering service.
– Rui F Ribeiro
15 mins ago
It is not possible to show a sample file here as the files are very big themselves and the lines are too long to post in the comments section.
– David
6 mins ago
The file is a sam file, obtained by alignment to a genome
– David
6 mins ago
I have very little knowledge of linux, hence the question
– David
5 mins ago
@David Then cut the length of the line so that it's manageable, while still allowing someone to properly test a solution against it. You've said nothing about your file apart from that it has a header and fields.
– Kusalananda
11 secs ago
add a comment |
Please add samples of the output and input, tell us what was done until now and where you might enlighten you. This is a Unix questions site, not a script delivering service.
– Rui F Ribeiro
15 mins ago
It is not possible to show a sample file here as the files are very big themselves and the lines are too long to post in the comments section.
– David
6 mins ago
The file is a sam file, obtained by alignment to a genome
– David
6 mins ago
I have very little knowledge of linux, hence the question
– David
5 mins ago
@David Then cut the length of the line so that it's manageable, while still allowing someone to properly test a solution against it. You've said nothing about your file apart from that it has a header and fields.
– Kusalananda
11 secs ago
Please add samples of the output and input, tell us what was done until now and where you might enlighten you. This is a Unix questions site, not a script delivering service.
– Rui F Ribeiro
15 mins ago
Please add samples of the output and input, tell us what was done until now and where you might enlighten you. This is a Unix questions site, not a script delivering service.
– Rui F Ribeiro
15 mins ago
It is not possible to show a sample file here as the files are very big themselves and the lines are too long to post in the comments section.
– David
6 mins ago
It is not possible to show a sample file here as the files are very big themselves and the lines are too long to post in the comments section.
– David
6 mins ago
The file is a sam file, obtained by alignment to a genome
– David
6 mins ago
The file is a sam file, obtained by alignment to a genome
– David
6 mins ago
I have very little knowledge of linux, hence the question
– David
5 mins ago
I have very little knowledge of linux, hence the question
– David
5 mins ago
@David Then cut the length of the line so that it's manageable, while still allowing someone to properly test a solution against it. You've said nothing about your file apart from that it has a header and fields.
– Kusalananda
11 secs ago
@David Then cut the length of the line so that it's manageable, while still allowing someone to properly test a solution against it. You've said nothing about your file apart from that it has a header and fields.
– Kusalananda
11 secs ago
add a comment |
0
active
oldest
votes
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
});
}
});
David is a new contributor. Be nice, and check out our Code of Conduct.
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%2f503265%2fextract-lines-from-a-file-with-a-value-whose-parameter-greater-than-100-with-gr%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
David is a new contributor. Be nice, and check out our Code of Conduct.
David is a new contributor. Be nice, and check out our Code of Conduct.
David is a new contributor. Be nice, and check out our Code of Conduct.
David is a new contributor. Be nice, and check out our Code of Conduct.
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%2f503265%2fextract-lines-from-a-file-with-a-value-whose-parameter-greater-than-100-with-gr%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
Please add samples of the output and input, tell us what was done until now and where you might enlighten you. This is a Unix questions site, not a script delivering service.
– Rui F Ribeiro
15 mins ago
It is not possible to show a sample file here as the files are very big themselves and the lines are too long to post in the comments section.
– David
6 mins ago
The file is a sam file, obtained by alignment to a genome
– David
6 mins ago
I have very little knowledge of linux, hence the question
– David
5 mins ago
@David Then cut the length of the line so that it's manageable, while still allowing someone to properly test a solution against it. You've said nothing about your file apart from that it has a header and fields.
– Kusalananda
11 secs ago