Trjtdtk

How to report a triplet of septets in NMR tabulation?

Could a US political party gain complete control over the government by removing checks & balances?

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

N.B. ligature in Latex

How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?

Extreme, but not acceptable situation and I can't start the work tomorrow morning

Japan - Plan around max visa duration

Why is the design of haulage companies so “special”?

What does "enim et" mean?

Download, install and reboot computer at night if needed

Why is this code 6.5x slower with optimizations enabled?

Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941?

Chess with symmetric move-square

Is it possible to do 50 km distance without any previous training?

DOS, create pipe for stdin/stdout of command.com(or 4dos.com) in C or Batch?

The use of multiple foreign keys on same column in SQL Server

How can the DM most effectively choose 1 out of an odd number of players to be targeted by an attack or effect?

Do airline pilots ever risk not hearing communication directed to them specifically, from traffic controllers?

Non-Jewish family in an Orthodox Jewish Wedding

A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?

Why do we use polarized capacitor?

How to type dʒ symbol (IPA) on Mac?

Why don't electron-positron collisions release infinite energy?

Patience, young "Padovan"

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♦

44.7k1163145

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♦

44.7k1163145

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♦

44.7k1163145

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♦

44.7k1163145

asked Mar 30 at 10:06

newstudentnewstudent

454

share|improve this question

edited Mar 30 at 10:48

Jeff Schaller♦

44.7k1163145

asked Mar 30 at 10:06

newstudentnewstudent

454

edited Mar 30 at 10:48

Jeff Schaller♦

44.7k1163145

edited Mar 30 at 10:48

Jeff Schaller♦

44.7k1163145

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♦

140k17261435

answered Mar 30 at 10:08

SjoerdSjoerd

32328

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♦

44.7k1163145

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,7391311

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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♦

140k17261435

answered Mar 30 at 10:08

SjoerdSjoerd

32328

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♦

140k17261435

answered Mar 30 at 10:08

SjoerdSjoerd

32328

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♦

140k17261435

answered Mar 30 at 10:08

SjoerdSjoerd

32328

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

awk 'print $2; nextfile' file*

share|improve this answer

edited Mar 30 at 10:50

Kusalananda♦

140k17261435

answered Mar 30 at 10:08

SjoerdSjoerd

32328

edited Mar 30 at 10:50

Kusalananda♦

140k17261435

edited Mar 30 at 10:50

Kusalananda♦

140k17261435

answered Mar 30 at 10:08

SjoerdSjoerd

32328

answered Mar 30 at 10:08

SjoerdSjoerd

32328

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♦

44.7k1163145

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,7391311

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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♦

44.7k1163145

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,7391311

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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♦

44.7k1163145

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,7391311

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♦

44.7k1163145

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,7391311

edited Mar 31 at 13:46

Jeff Schaller♦

44.7k1163145

edited Mar 31 at 13:46

Jeff Schaller♦

44.7k1163145

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,7391311

answered Mar 31 at 13:44

Praveen Kumar BSPraveen Kumar BS

1,7391311