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
Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?
TikZ: How to fill area with a special pattern?
Could a dragon use its wings to swim?
Is there a way to save my career from absolute disaster?
Why don't programming languages automatically manage the synchronous/asynchronous problem?
Is it correct to say moon starry nights?
Point distance program written without a framework
Film where the government was corrupt with aliens, people sent to kill aliens are given rigged visors not showing the right aliens
Strange use of "whether ... than ..." in official text
What happened in Rome, when the western empire "fell"?
How do you define an element with an ID attribute using LWC?
What flight has the highest ratio of timezone difference to flight time?
Players Circumventing the limitations of Wish
How did Beeri the Hittite come up with naming his daughter Yehudit?
Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?
Is dried pee considered dirt?
What was Carter Burke's job for "the company" in Aliens?
Is there a difference between "Fahrstuhl" and "Aufzug"?
Is fine stranded wire ok for main supply line?
Is French Guiana a (hard) EU border?
Do I need to write [sic] when including a quotation with a number less than 10 that isn't written out?
Why do we say 'Un seul M' and not 'Une seule M' even though M is a "consonne"
Why did early computer designers eschew integers?
If Nick Fury and Coulson already knew about aliens (Kree and Skrull) why did they wait until Thor's appearance to start making weapons?
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 yesterday
Jeff Schaller♦
44.4k1162143
asked yesterday
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 yesterday
Jeff Schaller♦
44.4k1162143
asked yesterday
newstudentnewstudent
484
1
Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
– Kusalananda♦
yesterday
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 yesterday
Jeff Schaller♦
44.4k1162143
asked yesterday
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 yesterday
Jeff Schaller♦
44.4k1162143
asked yesterday
newstudentnewstudent
484
edited yesterday
Jeff Schaller♦
44.4k1162143
asked yesterday
newstudentnewstudent
484
edited yesterday
Jeff Schaller♦
44.4k1162143
edited yesterday
Jeff Schaller♦
44.4k1162143
edited yesterday
Jeff Schaller♦
44.4k1162143
44.4k1162143
asked yesterday
newstudentnewstudent
484
asked yesterday
newstudentnewstudent
484
asked yesterday
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♦
yesterday
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♦
yesterday
1
1
Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
– Kusalananda♦
yesterday
Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
– Kusalananda♦
yesterday
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 yesterday
Kusalananda♦
139k17259429
answered yesterday
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 15 hours ago
Jeff Schaller♦
44.4k1162143
answered 15 hours ago
Praveen Kumar BSPraveen Kumar BS
1,7161311
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♦
15 hours ago
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 yesterday
Kusalananda♦
139k17259429
answered yesterday
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 yesterday
Kusalananda♦
139k17259429
answered yesterday
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 yesterday
Kusalananda♦
139k17259429
answered yesterday
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 yesterday
Kusalananda♦
139k17259429
answered yesterday
SjoerdSjoerd
31328
edited yesterday
Kusalananda♦
139k17259429
edited yesterday
Kusalananda♦
139k17259429
edited yesterday
Kusalananda♦
139k17259429
139k17259429
answered yesterday
SjoerdSjoerd
31328
answered yesterday
SjoerdSjoerd
31328
answered yesterday
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 15 hours ago
Jeff Schaller♦
44.4k1162143
answered 15 hours ago
Praveen Kumar BSPraveen Kumar BS
1,7161311
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♦
15 hours ago
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 15 hours ago
Jeff Schaller♦
44.4k1162143
answered 15 hours ago
Praveen Kumar BSPraveen Kumar BS
1,7161311
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♦
15 hours ago
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 15 hours ago
Jeff Schaller♦
44.4k1162143
answered 15 hours ago
Praveen Kumar BSPraveen Kumar BS
1,7161311
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 15 hours ago
Jeff Schaller♦
44.4k1162143
answered 15 hours ago
Praveen Kumar BSPraveen Kumar BS
1,7161311
edited 15 hours ago
Jeff Schaller♦
44.4k1162143
edited 15 hours ago
Jeff Schaller♦
44.4k1162143
edited 15 hours ago
Jeff Schaller♦
44.4k1162143
44.4k1162143
answered 15 hours ago
Praveen Kumar BSPraveen Kumar BS
1,7161311
answered 15 hours ago
Praveen Kumar BSPraveen Kumar BS
1,7161311
answered 15 hours ago
Praveen Kumar BSPraveen Kumar BS
1,7161311
1,7161311
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♦
15 hours ago
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♦
15 hours ago
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♦
15 hours ago
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♦
15 hours ago
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♦
yesterday