|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Merge 2 text files to one text file side by side
Post 302283154 by Revo on Monday 2nd of February 2009 05:11:59 PM
02-02-2009
Hi, can I just jump in here 
as a noob i'd not heard of the paste command, and was quite interested in what it could do. I tried the command as suggested
#paste -d' 'filea fileb > filec and got the same results as the OP, in that only details from the second file were being picked up.
however with a quick blurt at the man page i tried again, with some spaces that were not originally apparent from the suggested post
dave@freya:~$ paste -d ' ' 113_lat.txt 113_lon.txt > latlon.txt
dave@freya:~$ cat latlon.txt
2644.989500 5104.146495
2645.791200 5103.428400
2647.358600 5103.305700
2647.358300 5103.446300
2647.338700 5103.442100
2647.307900 5103.538900
2647.312100 5103.875200
2647.240400 5104.080100
2647.000300 5105.286800
2646.618800 5105.493300
2646.472100 5105.901000
2646.358800 5106.284000
note the spaces between the -d the ' symbols and the first filename
(run on opensolaris and bash shell if that helps)
Anyhoo thanks for an interesting little tip
as a noob i'd not heard of the paste command, and was quite interested in what it could do. I tried the command as suggested
#paste -d' 'filea fileb > filec and got the same results as the OP, in that only details from the second file were being picked up.
however with a quick blurt at the man page i tried again, with some spaces that were not originally apparent from the suggested post
dave@freya:~$ paste -d ' ' 113_lat.txt 113_lon.txt > latlon.txt
dave@freya:~$ cat latlon.txt
2644.989500 5104.146495
2645.791200 5103.428400
2647.358600 5103.305700
2647.358300 5103.446300
2647.338700 5103.442100
2647.307900 5103.538900
2647.312100 5103.875200
2647.240400 5104.080100
2647.000300 5105.286800
2646.618800 5105.493300
2646.472100 5105.901000
2646.358800 5106.284000
note the spaces between the -d the ' symbols and the first filename
(run on opensolaris and bash shell if that helps)
Anyhoo thanks for an interesting little tip
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
Input file_1:
P78811
P40108
O17861
Q6NTW1
P40986
Q6PBK1
P38264
Q6PBK1
Q9CZ49
Q1GZI0
Input file_2: (6 Replies)
Discussion started by: patrick87
6 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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
LEARN ABOUT MOJAVE
creatbyproc.d
creatbyproc.d(1m) USER COMMANDS creatbyproc.d(1m) NAME
creatbyproc.d - snoop creat()s by process name. Uses DTrace. SYNOPSIS
creatbyproc.d DESCRIPTION
creatbyproc.d is a DTrace OneLiner to print file creations as it occurs, including the name of the process calling the open. This matches file creates from the creat() system call; not all file creation occurs in this way, sometimes it is through open() with a O_CREAT flag, this script will not monitor that activity. Docs/oneliners.txt and Docs/Examples/oneliners_examples.txt in the DTraceToolkit contain this as a oneliner that can be cut-n-paste to run. Since this uses DTrace, only users with root privileges can run this command. EXAMPLES
This prints process names and new pathnames until Ctrl-C is hit. # creatbyproc.d FIELDS
CPU The CPU that recieved the event ID A DTrace probe ID for the event FUNCTION:NAME The DTrace probe name for the event remaining fields The first is the name of the process, the second is the file pathname. DOCUMENTATION
See the DTraceToolkit for further documentation under the Docs directory. The DTraceToolkit docs may include full worked examples with ver- bose descriptions explaining the output. EXIT
creatbyproc.d will run forever until Ctrl-C is hit. AUTHOR
Brendan Gregg [Sydney, Australia] SEE ALSO
dtrace(1M) version 1.00 Jun 11, 2005 creatbyproc.d(1m)