How to combine 2 files into 1 file with 2 columns


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to combine 2 files into 1 file with 2 columns
# 1  
Old 06-19-2011
How to combine 2 files into 1 file with 2 columns

Hi Guys,

I want to combine 2 files and and put together in 1 file and make two columns out it. See below desired output. Any help will be much appreciated.


inputfile1.txt
Code:
12345
67890
24580

inputfile2.txt
Code:
AAAAA
BBBBB
CCCCC



DESIRED OUTPUT:
outputfile.txt
Code:
12345     AAAAA
67890     BBBBB
24580     CCCCC


Thanks in advance!


Br,
Pinpe
# 2  
Old 06-19-2011
Code:
paste inputfile1.txt inputfile2.txt > outputfile.txt

# 3  
Old 06-19-2011
Quote:
Originally Posted by Scrutinizer
Code:
paste inputfile1.txt inputfile2.txt > outputfile.txt

Hi Scrutinizer,

This is great! Thanks dude! But the output show that it has a 5 spaces in between the columns. I want to make it 1 space only as shown below.


Code:
paste inputfile1.txt inputfile2.txt > outputfile.txt

12345     AAAAA
67890     BBBBB
24580     CCCCC



DESIRED OUTPUT:
Code:
12345 AAAAA
67890 BBBBB
24580 CCCCC



Thanks again in advance.


Br,
Pinpe
# 4  
Old 06-19-2011
Code:
paste -d" " inputfile1.txt inputfile2.txt > outputfile.txt

PS: those are not spaces that separate the columns, but TABs Smilie
# 5  
Old 06-20-2011
Code:
#(cat t1 ; cat  t2 ) | xargs -n 2
12345 67890
24580 AAAAA
BBBBB CCCCC

# 6  
Old 06-20-2011
@Honglus: that is not what is required..
# 7  
Old 06-20-2011
Code:
# awk 'NR==FNR{a[i++]=$0};{b[x++]=$0;};{k=x-i};END{for(j=0;j<i;) print a[j++],b[k++]}' inputfile1.txt inputfile2.txt 
12345 AAAAA
67890 BBBBB
24580 CCCCC

regards
ygemici
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Combine Columns

Input NJ090237_0263_GRP,NJ090237_0263_VIEW,NJ090237_0263_PSGRP,NJ090237_0263_GOLD_CSGRP,06E:0_08E:0_09E:0_11E:0,0CE5 NJ090237_0264_GRP,NJ090237_0263_VIEW,NJ090237_0264_PSGRP,NJ090237_0263_GOLD_CSGRP,06E:0_08E:0_09E:0_11E:0,0CE5... (7 Replies)
Discussion started by: greycells
7 Replies

2. Shell Programming and Scripting

Combine data out of 3 files into one new file

Hi, How can I combine the data of of three files into one new file? I try to give as much informations as possible. The three existing files are called file1 file2 and file3 the new file should named output_combined. The size of the files will be around 900 words/lines each .. but always... (5 Replies)
Discussion started by: MyMemberName
5 Replies

3. Shell Programming and Scripting

Combine columns from many files but keep them aligned in columns-shorter left column issue

Hello everyone, I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble. I have many files each having two columns and hundreds of rows. first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Discussion started by: isildur1234
5 Replies

4. UNIX for Dummies Questions & Answers

Combine columns from 100 files with same structure

Hi, I have a bunch of files with the following format. PUR.1.9 30910 0.024 0.926 0.050 36587 0.024 0.927 0.049 91857 0.023 0.928 0.049 105797 0.024 0.927 0.049 146659 0.024 0.927 0.049 152695 0.024 0.927 0.049 192118 0.022 0.930 0.048 193310 0.018 0.936 0.046 PUR.2.9 30910 0.028... (6 Replies)
Discussion started by: genehunter
6 Replies

5. Shell Programming and Scripting

Combine columns from multiple files

Can anybody help on the script to combine/concatenate columns from multiple files input1 4 135 5 185 6 85 11 30 16 72 17 30 21 52 22 76 input2 2 50 4 50 6 33 8 62 10 25 12 46 14 42 15 46output (2 Replies)
Discussion started by: sdf
2 Replies

6. UNIX for Dummies Questions & Answers

How to combine 2 files with 6 columns?

This may seem obvious but I am having problems doing this as columns get converted to rows when i try to write a script. I have 2 files text1.txt and text2.txt each of which have 6 columns of numbers separated by a space. I need to combine the 2 files so that the output file text3.txt maintains... (2 Replies)
Discussion started by: tgoldstone
2 Replies

7. UNIX for Dummies Questions & Answers

combine the values from the first two columns within a file

Hello everybody, I have a text file containing 10,000 rows and 5000 columns. The values are separated by a tab. Ex. file_ex.ped 1 mike 0 0 2 1 A A G G C T A G 1 jack 0 0 2 2 T A G T C A A C 1 Mary 0 0 1 2 A T G C A T G C ... I would like a out put file 1 mike 0 0 2 1 AA GG CT AG 1... (7 Replies)
Discussion started by: Unilearn
7 Replies

8. Shell Programming and Scripting

get data from files combine them to a file

hi people; this is my file1.txt:192.168.1.1 192.168.1.2 192.168.1.3 192.168.1.4 ... this is my file2.txt:portnames usernames maxusercap ... i want to write to file3.txt:l ./getports 192.168.1.1 'get all;l+;get . portnames;l-' l ./getports 192.168.1.1 'get all;l+;get . usernames;l-'... (4 Replies)
Discussion started by: gc_sw
4 Replies

9. Shell Programming and Scripting

Combine multiple columns from multiple files

Hi there, I was wondering if someone can help me with this. I am trying the combine multiple columns from multiple files into one file. Example file 1: c0t0d0 c0t2d0 # hostname vgname c0t0d1 c0t2d1 # hostname vgname c0t0d2 c0t2d2 # hostname vgname c0t1d0 c0t3d0 # hostname vgname1... (5 Replies)
Discussion started by: martva
5 Replies

10. UNIX for Dummies Questions & Answers

combine text files into one file

I need to write a shell script which combines/joins 3 text files into one file. Do i put the txt files in the same folder as my script? Here is what i have: #!/bin/bash file1=$1 file2=$2 file3=$3 out="output.txt" count=0 if then echo "$(basename $0) file1 file2 file3" ... (3 Replies)
Discussion started by: zzthejimzz
3 Replies
Login or Register to Ask a Question