Hcfyk

How can internet speed be 10 times slower without a router than when using a router?

Find magical solution to magical equation

Adding command shortcuts to /bin

Extra space in cells when using token lists to build tabular content

Is “snitty” a popular American English term? What is its origin?

Is 'contemporary' ambiguous and if so is there a better word?

Should I decline this job offer that requires relocating to an area with high cost of living?

Gladys unchained

Can you use "едать" and "игрывать" in the present and future tenses?

Why do these characters still seem to be the same age after the events of Endgame?

Outlining A Novel - How do you make it less of a slog?

Salt turned peas from creamy to crunchy

Is there a word that describes the unjustified use of a more complex word?

How can I get people to remember my character's gender?

History of the kernel of a homomorphism?

How do I, as a DM, handle a party that decides to set up an ambush in a dungeon?

Pressure inside an infinite ocean?

What was Bran's plan to kill the Night King?

Is there precedence or are there procedures for a US president refusing to concede to an electoral defeat?

Is the book wrong about the Nyquist sampling cirteria?

Endgame puzzle: How to avoid stalemate and win?

What do "Sech" and "Vich" mean in this sentence?

Using Im[] and Re[] Correctly

Is disk brake effectiveness mitigated by tyres losing traction under strong braking?

Combine columns from several files into one

combine 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

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

4

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

share|improve this question

edited Mar 30 at 10:48

Jeff Schaller♦

45.5k1165148

asked Mar 30 at 10:06

newstudentnewstudent

454

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
  
  – Kusalananda♦
  Mar 30 at 10:49
  

  
  
  
  

add a comment | 

4

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

share|improve this question

edited Mar 30 at 10:48

Jeff Schaller♦

45.5k1165148

asked Mar 30 at 10:06

newstudentnewstudent

454

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Are the files named in such a way that a filename globbing pattern would list them in the correct sequence?
  
  – Kusalananda♦
  Mar 30 at 10:49
  

  
  
  
  

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

share|improve this question

edited Mar 30 at 10:48

Jeff Schaller♦

45.5k1165148

asked Mar 30 at 10:06

newstudentnewstudent

454

1 100
2 103 

1 200
2 203

100
200
.
.
. (600 lines)

share|improve this question

edited Mar 30 at 10:48

Jeff Schaller♦

45.5k1165148

asked Mar 30 at 10:06

newstudentnewstudent

454

share|improve this question

edited Mar 30 at 10:48

Jeff Schaller♦

45.5k1165148

asked Mar 30 at 10:06

newstudentnewstudent

454

edited Mar 30 at 10:48

Jeff Schaller♦

45.5k1165148

edited Mar 30 at 10:48

Jeff Schaller♦

45.5k1165148

asked Mar 30 at 10:06

newstudentnewstudent

454

asked Mar 30 at 10:06

newstudentnewstudent

454

2 Answers
2

active

oldest

votes

8

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*

share|improve this answer

edited Mar 30 at 10:50

Kusalananda♦

145k18272452

answered Mar 30 at 10:08

SjoerdSjoerd

34329

add a comment | 

1

Best answer has been given above. Tried with below command

for i in file1 file2; do awk 'NR==1print $2' $i; done
100
200

share|improve this answer

edited Mar 31 at 13:46

Jeff Schaller♦

45.5k1165148

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,8102311

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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♦
  Mar 31 at 13:46
  

  
  
  
  

add a comment | 

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

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

Name

Email

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

Name

Email

Required, but never shown

8

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*

share|improve this answer

edited Mar 30 at 10:50

Kusalananda♦

145k18272452

answered Mar 30 at 10:08

SjoerdSjoerd

34329

add a comment | 

8

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*

share|improve this answer

edited Mar 30 at 10:50

Kusalananda♦

145k18272452

answered Mar 30 at 10:08

SjoerdSjoerd

34329

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*

share|improve this answer

edited Mar 30 at 10:50

Kusalananda♦

145k18272452

answered Mar 30 at 10:08

SjoerdSjoerd

34329

awk 'FNR==1 print $2' file*

awk 'print $2; nextfile' file*

share|improve this answer

edited Mar 30 at 10:50

Kusalananda♦

145k18272452

answered Mar 30 at 10:08

SjoerdSjoerd

34329

edited Mar 30 at 10:50

Kusalananda♦

145k18272452

edited Mar 30 at 10:50

Kusalananda♦

145k18272452

answered Mar 30 at 10:08

SjoerdSjoerd

34329

answered Mar 30 at 10:08

SjoerdSjoerd

34329

1

Best answer has been given above. Tried with below command

for i in file1 file2; do awk 'NR==1print $2' $i; done
100
200

share|improve this answer

edited Mar 31 at 13:46

Jeff Schaller♦

45.5k1165148

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,8102311

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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♦
  Mar 31 at 13:46
  

  
  
  
  

add a comment | 

1

Best answer has been given above. Tried with below command

for i in file1 file2; do awk 'NR==1print $2' $i; done
100
200

share|improve this answer

edited Mar 31 at 13:46

Jeff Schaller♦

45.5k1165148

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,8102311

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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♦
  Mar 31 at 13:46
  

  
  
  
  

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

share|improve this answer

edited Mar 31 at 13:46

Jeff Schaller♦

45.5k1165148

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,8102311

for i in file1 file2; do awk 'NR==1print $2' $i; done
100
200

share|improve this answer

edited Mar 31 at 13:46

Jeff Schaller♦

45.5k1165148

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,8102311

edited Mar 31 at 13:46

Jeff Schaller♦

45.5k1165148

edited Mar 31 at 13:46

Jeff Schaller♦

45.5k1165148

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,8102311

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,8102311