Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

how to combine two files together, not by row buy by column

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers how to combine two files together, not by row buy by column
# 1  
Old 02-14-2009
Power how to combine two files together, not by row buy by column
let's say, we have:
x1.txt
1 2
3 4
5 6

x2.txt
7 8
9 10
11 12

is there a very simple command like 'cat' that can makes them combine into x3.txt :
1 2 7 8
3 4 9 10
5 6 11 12
Thanks so much for help me with the dummiest questionsSmilie
# 2  
Old 02-14-2009
Use paste command, man for more info... Thanks!
[root@ganen test]# cat x1.txt
1 2
3 4
5 6
[root@ganen test]# cat x2.txt
7 8
9 10
11 12
[root@ganen test]# paste -d" " x1.txt x2.txt
1 2 7 8
3 4 9 10
5 6 11 12
# 3  
Old 02-14-2009
Code:
$ paste -d ' ' x1.txt x2.txt > x3.txt

# 4  
Old 02-15-2009
Thanks so much!!

Quote:
Originally Posted by timontt
Use paste command, man for more info... Thanks!
[root@ganen test]# cat x1.txt
1 2
3 4
5 6
[root@ganen test]# cat x2.txt
7 8
9 10
11 12
[root@ganen test]# paste -d" " x1.txt x2.txt
1 2 7 8
3 4 9 10
5 6 11 12
# 5  
Old 02-15-2009
THanks so much too!!

Quote:
Originally Posted by pludi
Code:
$ paste -d ' ' x1.txt x2.txt > x3.txt

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Select and copy .csv files based on row and column number

Dear UNIX experts, I'm a command line novice working on a Macintosh computer (Bash shell) and have neither found advice that is pertinent to my problem on the internet nor in this forum. I have hundreds of .csv files in a directory. Now I would like to copy the subset of files that contains... (8 Replies)
Discussion started by: rcsapo
8 Replies

2. Shell Programming and Scripting

Comparing same column from two files, printing whole row with matching values

First I'd like to apologize if I opened a thread which is already open somewhere. I did a bit of searching but could quite find what I was looking for, so I will try to explaing what I need. I'm writing a script on our server, got to a point where I have two files with results. Example: File1... (6 Replies)
Discussion started by: mitabrev83
6 Replies

3. Shell Programming and Scripting

Row bind multiple csv files having different column headers

All, I guess by this time someone asked this kind of question, but sorry I am unable to find after a deep search. Here is my request I have many files out of which 2 sample files provided below. File-1 (with A,B as column headers) A,B 1,2 File-2 (with C, D as column headers) C,D 4,5 I... (7 Replies)
Discussion started by: ks_reddy
7 Replies

4. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies

5. Shell Programming and Scripting

Combining multiple column files into one with file name as first row

Hello All, I have several column files like this $cat a_b_s1.xls 1wert 2tg 3asd 4asdf 5asdf $cat c_d_s2.xls 1wert 2tg 3asd 4asdf 5asdf desired put put $cat combined.txt s1 s2 (2 Replies)
Discussion started by: avatar_007
2 Replies

6. Shell Programming and Scripting

Help converting column to row for multiple files

Hi all, I am pretty new at this so be gentle. Also, if there is any chance you could explain what the code you use is actually doing, that would really help me out, Im learning after all :) So I am trying to convert a selected column of numbers from input file1 into a row in output file2 ... (3 Replies)
Discussion started by: StudentServitor
3 Replies

7. Shell Programming and Scripting

combine multiple files by column into one files already sorted!

I have multiple files; each file contains a certain data in a column view simply i want to combine all those files into one file in columns example file1: a b c d file 2: 1 2 3 4 file 3: G (4 Replies)
Discussion started by: ahmedamro
4 Replies

8. Shell Programming and Scripting

Combine Multiple text or csv files column-wise

Hi All I am trying to combine columns from multiple text files into a single file using paste command but the record length being unequal in the different files the data is running over to the closest empty cell on the left. Please see below. What can i do to resolve this ? File 1 File... (15 Replies)
Discussion started by: venky_ibm
15 Replies

9. Shell Programming and Scripting

Moving data from a specified column/row to another column/row

Hello, I have an input file like the following: 11_3_4 2_1_35 3_15__ _16989 Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies

10. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like... (9 Replies)
Discussion started by: aYankeeFan
9 Replies
Login or Register to Ask a Question