Combine columns from several files into one The Next CEO of Stack Overflowcombine text files column-wiseParse several thousand lines of txt into lines and columnsPick columns from a variable length csv filecombine two files to single file with combined columnsCompare columns between different filesConcatenate several files with a common headerCombine columns using awk? (Or other suggestions)How to combine two files by shifting the value of the row file to its corresponding value in the column file?How to join rows with single columns to a maximum of 4 columns in one row?How to combine columns of two files, remove duplicates, and fill in missing lines
Noise during hard braking
Is there a rule of thumb for determining the amount one should accept for of a settlement offer?
Compensation for working overtime on Saturdays
Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?
Masking layers by a vector polygon layer in QGIS
Can Sri Krishna be called 'a person'?
How dangerous is XSS
Horror film about a man brought out of cryogenic suspension without a soul, around 1990
Are British MPs missing the point, with these 'Indicative Votes'?
Man transported from Alternate World into ours by a Neutrino Detector
Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico
Avoiding the "not like other girls" trope?
Ising model simulation
Raspberry pi 3 B with Ubuntu 18.04 server arm64: what chip
My boss doesn't want me to have a side project
Does int main() need a declaration on C++?
An elegant way to define a sequence
Omega? Krypton?
Can you teleport closer to a creature you are Frightened of?
Is it possible to make a 9x9 table fit within the default margins?
What steps are necessary to read a Modern SSD in Medieval Europe?
Words hidden in my phone number
Salesforce opportunity stages
What day is it again?
Combine columns from several files into one
The Next CEO of Stack Overflowcombine text files column-wiseParse several thousand lines of txt into lines and columnsPick columns from a variable length csv filecombine two files to single file with combined columnsCompare columns between different filesConcatenate several files with a common headerCombine columns using awk? (Or other suggestions)How to combine two files by shifting the value of the row file to its corresponding value in the column file?How to join rows with single columns to a maximum of 4 columns in one row?How to combine columns of two files, remove duplicates, and fill in missing lines
I have several files with two columns :
file 1:
1 100
2 103
file 2
1 200
2 203
and around 600 such files with two columns.
Now, I would like to combine the second column in every file of the first row in the correct sequence to get a single data file like :
100
200
.
.
. (600 lines)
How do I do that?
text-processing awk
edited 2 days ago
Jeff Schaller♦
44.4k1162143
asked 2 days ago
newstudentnewstudent
484
add a comment |
I have several files with two columns :
file 1:
1 100
2 103
file 2
1 200
2 203
and around 600 such files with two columns.
Now, I would like to combine the second column in every file of the first row in the correct sequence to get a single data file like :
100
200
.
.
. (600 lines)
How do I do that?
text-processing awk
edited 2 days ago
Jeff Schaller♦
44.4k1162143
asked 2 days ago
newstudentnewstudent
484
1
Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
– Kusalananda♦
2 days ago
add a comment |
I have several files with two columns :
file 1:
1 100
2 103
file 2
1 200
2 203
and around 600 such files with two columns.
Now, I would like to combine the second column in every file of the first row in the correct sequence to get a single data file like :
100
200
.
.
. (600 lines)
How do I do that?
text-processing awk
edited 2 days ago
Jeff Schaller♦
44.4k1162143
asked 2 days ago
newstudentnewstudent
484
I have several files with two columns :
file 1:
1 100
2 103
file 2
1 200
2 203
and around 600 such files with two columns.
Now, I would like to combine the second column in every file of the first row in the correct sequence to get a single data file like :
100
200
.
.
. (600 lines)
How do I do that?
text-processing awk
text-processing awk
edited 2 days ago
Jeff Schaller♦
44.4k1162143
asked 2 days ago
newstudentnewstudent
484
edited 2 days ago
Jeff Schaller♦
44.4k1162143
asked 2 days ago
newstudentnewstudent
484
edited 2 days ago
Jeff Schaller♦
44.4k1162143
edited 2 days ago
Jeff Schaller♦
44.4k1162143
edited 2 days ago
Jeff Schaller♦
44.4k1162143
44.4k1162143
asked 2 days ago
newstudentnewstudent
484
asked 2 days ago
newstudentnewstudent
484
asked 2 days ago
newstudentnewstudent
484
484
1
Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
– Kusalananda♦
2 days ago
add a comment |
1
Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
– Kusalananda♦
2 days ago
1
1
Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
– Kusalananda♦
2 days ago
Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
– Kusalananda♦
2 days ago
add a comment |
2 Answers
2
active
oldest
votes
awk 'FNR==1 print $2' file*
This prints the second column ($2) of the first line (FNR==1) for every file whose filename starts with file.
An alternative is to print the first line and then immediately skip to the next file (nextfile is a mawk and GNU awk-specific keyword):
awk 'print $2; nextfile' file*
edited 2 days ago
Kusalananda♦
139k17259430
answered 2 days ago
SjoerdSjoerd
31328
add a comment |
Best answer has been given above. Tried with below command
for i in file1 file2; do awk 'NR==1print $2' $i; done
100
200
edited yesterday
Jeff Schaller♦
44.4k1162143
answered yesterday
Praveen Kumar BSPraveen Kumar BS
1,7101311
I'd suggest at least using a wildcard for theforloop, as the OP indicated "around 600 such files" -- so that they don't have to type out each one. Also quote$ias"$i"when you refer to it, otherwise your solution will break on files named, for example:file number 5.
– Jeff Schaller♦
yesterday
add a comment |
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%2f509572%2fcombine-columns-from-several-files-into-one%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
awk 'FNR==1 print $2' file*
This prints the second column ($2) of the first line (FNR==1) for every file whose filename starts with file.
An alternative is to print the first line and then immediately skip to the next file (nextfile is a mawk and GNU awk-specific keyword):
awk 'print $2; nextfile' file*
edited 2 days ago
Kusalananda♦
139k17259430
answered 2 days ago
SjoerdSjoerd
31328
add a comment |
awk 'FNR==1 print $2' file*
This prints the second column ($2) of the first line (FNR==1) for every file whose filename starts with file.
An alternative is to print the first line and then immediately skip to the next file (nextfile is a mawk and GNU awk-specific keyword):
awk 'print $2; nextfile' file*
edited 2 days ago
Kusalananda♦
139k17259430
answered 2 days ago
SjoerdSjoerd
31328
add a comment |
awk 'FNR==1 print $2' file*
This prints the second column ($2) of the first line (FNR==1) for every file whose filename starts with file.
An alternative is to print the first line and then immediately skip to the next file (nextfile is a mawk and GNU awk-specific keyword):
awk 'print $2; nextfile' file*
edited 2 days ago
Kusalananda♦
139k17259430
answered 2 days ago
SjoerdSjoerd
31328
awk 'FNR==1 print $2' file*
This prints the second column ($2) of the first line (FNR==1) for every file whose filename starts with file.
An alternative is to print the first line and then immediately skip to the next file (nextfile is a mawk and GNU awk-specific keyword):
awk 'print $2; nextfile' file*
edited 2 days ago
Kusalananda♦
139k17259430
answered 2 days ago
SjoerdSjoerd
31328
edited 2 days ago
Kusalananda♦
139k17259430
edited 2 days ago
Kusalananda♦
139k17259430
edited 2 days ago
Kusalananda♦
139k17259430
139k17259430
answered 2 days ago
SjoerdSjoerd
31328
answered 2 days ago
SjoerdSjoerd
31328
answered 2 days ago
SjoerdSjoerd
31328
31328
add a comment |
add a comment |
Best answer has been given above. Tried with below command
for i in file1 file2; do awk 'NR==1print $2' $i; done
100
200
edited yesterday
Jeff Schaller♦
44.4k1162143
answered yesterday
Praveen Kumar BSPraveen Kumar BS
1,7101311
I'd suggest at least using a wildcard for theforloop, as the OP indicated "around 600 such files" -- so that they don't have to type out each one. Also quote$ias"$i"when you refer to it, otherwise your solution will break on files named, for example:file number 5.
– Jeff Schaller♦
yesterday
add a comment |
Best answer has been given above. Tried with below command
for i in file1 file2; do awk 'NR==1print $2' $i; done
100
200
edited yesterday
Jeff Schaller♦
44.4k1162143
answered yesterday
Praveen Kumar BSPraveen Kumar BS
1,7101311
I'd suggest at least using a wildcard for theforloop, as the OP indicated "around 600 such files" -- so that they don't have to type out each one. Also quote$ias"$i"when you refer to it, otherwise your solution will break on files named, for example:file number 5.
– Jeff Schaller♦
yesterday
add a comment |
Best answer has been given above. Tried with below command
for i in file1 file2; do awk 'NR==1print $2' $i; done
100
200
edited yesterday
Jeff Schaller♦
44.4k1162143
answered yesterday
Praveen Kumar BSPraveen Kumar BS
1,7101311
Best answer has been given above. Tried with below command
for i in file1 file2; do awk 'NR==1print $2' $i; done
100
200
edited yesterday
Jeff Schaller♦
44.4k1162143
answered yesterday
Praveen Kumar BSPraveen Kumar BS
1,7101311
edited yesterday
Jeff Schaller♦
44.4k1162143
edited yesterday
Jeff Schaller♦
44.4k1162143
edited yesterday
Jeff Schaller♦
44.4k1162143
44.4k1162143
answered yesterday
Praveen Kumar BSPraveen Kumar BS
1,7101311
answered yesterday
Praveen Kumar BSPraveen Kumar BS
1,7101311
answered yesterday
Praveen Kumar BSPraveen Kumar BS
1,7101311
1,7101311
I'd suggest at least using a wildcard for theforloop, as the OP indicated "around 600 such files" -- so that they don't have to type out each one. Also quote$ias"$i"when you refer to it, otherwise your solution will break on files named, for example:file number 5.
– Jeff Schaller♦
yesterday
add a comment |
I'd suggest at least using a wildcard for theforloop, as the OP indicated "around 600 such files" -- so that they don't have to type out each one. Also quote$ias"$i"when you refer to it, otherwise your solution will break on files named, for example:file number 5.
– Jeff Schaller♦
yesterday
I'd suggest at least using a wildcard for the
for loop, as the OP indicated "around 600 such files" -- so that they don't have to type out each one. Also quote $i as "$i" when you refer to it, otherwise your solution will break on files named, for example: file number 5.– Jeff Schaller♦
yesterday
I'd suggest at least using a wildcard for the
for loop, as the OP indicated "around 600 such files" -- so that they don't have to type out each one. Also quote $i as "$i" when you refer to it, otherwise your solution will break on files named, for example: file number 5.– Jeff Schaller♦
yesterday
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%2f509572%2fcombine-columns-from-several-files-into-one%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
1
Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
– Kusalananda♦
2 days ago