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
# 1  
Old 02-02-2009
Merge 2 text files to one text file side by side

Inquiring minds want to know.... I need to take two files that I have latitude and longitude values and then combine them into one file with the values side by side separated by a space.

the first file is temp113-lat.txt and the second is temp113-lon.txt. They each have values listed in the file like the example below

<temp113-lat.txt>
2644.989500
2645.791200
2647.358600
2647.358300
2647.338700
2647.307900
2647.312100
2647.240400
2647.000300
2646.618800
2646.472100
2646.358800

<temp113-lon.txt>
5104.146495
5103.428400
5103.305700
5103.446300
5103.442100
5103.538900
5103.875200
5104.080100
5105.286800
5105.493300
5105.901000
5106.284000


I want to take these and post them into a .txt file in the following format.

<113latlon.txt>
2644.989500 5104.146495
2645.791200 5103.428400
.... ....

I am trying to write a script to do this automatically but I am missing the line with the command string to do this function. I have tried to use the "paste" command and for some reason it will not output the correct format I want. anyone want to jump in on this one for me... I am at my limit.
# 2  
Old 02-02-2009
paste -d' ' filea fileb > filec

-d specifies the delimiter.
# 3  
Old 02-02-2009
That is what I thought. I am not really understanding what the problem is... I did that exact command and this is what I got

[77225 loc]$ paste -d' ' temp113-lat.txt temp113-lon.txt
5105.471900
5105.626300
5104.146495
5104.146495
5104.146495
5103.428400
5103.305700

This is only one of the files and it seperated at the beginning by a space. Why would it only be pulling the data from one file? I checked both files and they contain data. Could it be due to the fact there is a process to get these files? I am including the process in the script.

grep m_lat /113/*.log > /loc/temp113lat.txt
grep m_lon /113/*.log > /loc/temp113lon.txt
grep m_lat /114/*.log > /loc/temp114lat.txt
grep m_lon /114/*.log > /loc/temp114lon.txt
cd /loc
awk '{print $3}' temp113lat.txt > temp113-lat.txt
awk '{print $3}' temp113lon.txt > temp113-lon.txt
awk '{print $3}' temp114lat.txt > temp114-lat.txt
awk '{print $3}' temp114lon.txt > temp114-lon.txt
The next line would be the process to combine the files into one text file so the other program can read them. Any thoughts?
# 4  
Old 02-02-2009
no. it should work. are you sure that temp113-lat.txt has data?

i'd put some diagnostics following the awk scripts...
just /bin/ls -l or wc -l *
# 5  
Old 02-02-2009
I checked both of the files and they contain data.... I am really lost on this one...

Could it be the - in the file name?
# 6  
Old 02-02-2009
[77225 loc]$ wc -l temp113-lon.txt
52 temp113-lon.txt
[77225 loc]$ wc -l temp113-lat.txt
52 temp113-lat.txt
[77225 loc]$
# 7  
Old 02-02-2009
i might make the file names a little more different just so it's easier to tell what's what.
maybe therein is the problem.

maybe like this:

grep junk some_file > grep_some_file

awk junk grep_some_file > awk_some_file

paste -d' ' awk_some_file awk_some_other_file > paste_some_files



But copying everything you've mentioned -- from the original post -- and
trying it on my system - - - - paste -d' ' worked perfectly.

it looks like ~something~ is nuking that first file argument to the paste command,
or the file name is wrong maybe....
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