Merge 2 text files to one text file side by side


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Merge 2 text files to one text file side by side
# 15  
Old 02-04-2009
RedHat

Linux 2.6.18-92.1.22.el5 #1 SMP Fri Dec 5 09:29:46 EST 2008 i686 i686 i386 GNU/Linux

Here is the O/S and I am using a bash shell.

I tried what you are speaking of and i still get the same result. It is ignoring the first file and only outputting the second file. example below\

[67807 loc]$ paste -d ' ' temp113-lat.txt temp113-lon.txt > 113latlon2.txt
[67807 loc]$ cat 113latlon2.txt
5105.471900
5105.626300
5104.146495
5104.146495
5104.146495
5103.428400
5103.305700
5103.446300

[67807 loc]$ paste -d " " temp113-lat.txt temp113-lon.txt > 113latlon4.txt
[67807 loc]$ cat 113latlon4.txt
5105.471900
5105.626300
5104.146495
5104.146495
5104.146495
5103.428400
5103.305700

I am still getting the leading space as the delimiter but it is not reading the first file. but if I do it this way....

[67807 loc]$ paste temp113-lat.txt temp113-lon.txt > 113latlon5
[67807 loc]$ cat 113latlon5
2645.0805105.471900
2644.5485105.626300
2643.7325104.146495
2643.7325104.146495
2643.7325104.146495
2644.9895103.428400
2645.7915103.305700
2647.3585103.446300

I get both files and some of the first has been cut off. So I know it can read the file it just does not want to do it how I want. I am about to let this go and look for a work around on this problem. Is there any other way of doing this?

Thanks also to everyone who has posted help for this issue I appreciate such hospitality from the Unix.com community.

Last edited by ahinkebein; 02-04-2009 at 11:14 AM.. Reason: Update
# 16  
Old 02-04-2009
ok.... totally different approach since paste is causing you so much trouble:

Code:
#!/bin/ksh

len_a=$( wc -l < a )
len_b=$( wc -l < b )

if [ $len_a -gt $len_b ]; then
  max=$len_b
else
  max=$len_a
fi

(
head -n $max a
head -n $max b
) | pr -l$max -2

maybe cj can help make this POSIX compliant. Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging two text files side by side

Hi everyone, I need to merge two files side by side The files look something like this: HOSTNAME fishtornado-K52F 127.0.1.1 UPTIME 20:17:01 up 2:19, 3 users, load average: 0.00, 0.04, 0.05 DISK USAGE (Size/Used/Avail/Use%) 29G 6.5G 21G 25% RUN QUEUE PID COMMAND USER ... (4 Replies)
Discussion started by: FishTornado
4 Replies

2. Shell Programming and Scripting

Combining two single column files side-by-side

Hi, I am looking for a sed/awk script to join two large (~300 M) single column files (one is sorted and the other is not sorted) side-by-side. I have a shell script but its taking ages to do the task so looking for an optimized fast solution. The two files look like: File1 (sorted) a1... (1 Reply)
Discussion started by: sajal.bhatia
1 Replies

3. Shell Programming and Scripting

AWK to merge multiple files side by side

I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same. For example file1 contains cat dog File 2 contains rat mat Output file should be cat rat dog mat Using awk I was able to... (5 Replies)
Discussion started by: kanthrajgowda
5 Replies

4. Shell Programming and Scripting

printing 3 files side by side based on similar values in rows

Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns. For example: file1 ABC DEF GHI file2 DEF DER file3 ABC DER The output should come out like this file1 file2 file3 ABC ABC (4 Replies)
Discussion started by: zerofire123
4 Replies

5. Shell Programming and Scripting

Paste two file side by side together based on specific pattern match problem

Input file_1: P78811 P40108 O17861 Q6NTW1 P40986 Q6PBK1 P38264 Q6PBK1 Q9CZ49 Q1GZI0 Input file_2: (6 Replies)
Discussion started by: patrick87
6 Replies

6. Shell Programming and Scripting

How to Merge / combine / join / paste 2 text files side-by-side

I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer. For this example, file1 is longer: ---file1 Joe Bob Mary Sally Fred Elmer David ---file2 Tomato House Car... (3 Replies)
Discussion started by: cajunfries
3 Replies

7. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Hi Everyone, I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side. File1: a b c d 2 3 4 5 f g h i .......... File2: I II III IV w x y z .............. and so on many files are there...... (8 Replies)
Discussion started by: ks_reddy
8 Replies

8. Shell Programming and Scripting

Merge 3 columns side by side

I know this is a stupid question for you guys! half day googling and i got nothing :( i have 3 variables/files, say: $X1 or file1: # there is one whitespace space after each line | 21 | 9 | 28 | 100 | 51 $X2 or file2: # there is one whitespace space... (7 Replies)
Discussion started by: amaulana
7 Replies

9. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls bbc.xls Eno Ename Eno Ename 101 hello ... (2 Replies)
Discussion started by: jagadish99
2 Replies

10. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls Eno Ename 101 hello 102 hero 103 india bbc.xls Eno Ename 201 delhi 202 Hyd 203... (0 Replies)
Discussion started by: jagadish99
0 Replies
Login or Register to Ask a Question