how to merge two columns in different file and create third file

sam_nyc · 04-07-2022, 03:37 PM

Hello,

Code:

File 1.txt
1 2 3 4 5

File 2.txt
6

I need to file 3.txt
1 2 3 4 5 6

First file has five columns and second file one column. I like to merge both together.

I tried cat, didn't work. any other idea, your help is greatly appreciated.

wpeckham · 04-07-2022, 04:35 PM

man paste

TB0ne · 04-07-2022, 05:18 PM

Quote:

Originally Posted by sam_nyc

Hello,

Code:

File 1.txt
1 2 3 4 5

File 2.txt
6

I need to file 3.txt
1 2 3 4 5 6

First file has five columns and second file one column. I like to merge both together. I tried cat, didn't work. any other idea, your help is greatly appreciated.

Sounds familiar:
https://www.linuxquestions.org/quest...ne-4175708826/
https://www.linuxquestions.org/quest...ea-4175704050/
https://www.linuxquestions.org/quest...ng-4175692071/
https://www.linuxquestions.org/quest...rd-4175675529/

Been at least two years you've been working with scripting, and over TEN for Linux; why don't you show us exactly what you did try, and how you applied things you've been told before, to try to solve your problem, rather than just asking us to do it??

sam_nyc · 04-08-2022, 08:47 AM

Thank you so much for your help. This is what I did.

paste file{1,2} | awk '{print $1,$2,$3,$6}' > file3

TB0ne · 04-08-2022, 09:47 AM

Quote:

Originally Posted by sam_nyc

Thank you so much for your help. This is what I did.

Code:

paste file{1,2} | awk '{print $1,$2,$3,$6}' > file3

Did you actually read the man page on paste, and what it does? Or think back to your previous TEN YEARS experience???

Code:

paste 1 2 | sed 's/\t/ /g' > 3

wpeckham · 04-08-2022, 02:23 PM

Of course someone with only a year or two of experience MIGHT have tried

Code:

paste file{1,2}|expand|tr -s ' '

just to see what that might do.