05-30-2005
merging 2 files starting at the n'th line of the first file
Hi all,
I wonder if anyone could help me: I want to merge 3 files
together as shown below
I've seen the post adding columns from 01-05-2002, 09:23 AM
so know how to put 2 files together
basically I want to take output file of 1st merge and merge it with a 3rd file
but only start the merging at the n'th line of the file
so got output something like
line1 file1 line1 file2
line2 file1 line2 file2
line3 file1 line1 file3
line4 file1 line2 file3
line5 file1 line3 file3
for eample
file1:
2 3 0
6 2 0
2 3 1
5 3 1
6 9 1
file2
2 2 2
2 2 2
paste -d " " file1 file2 >"outputfile1"
outputfile1
2 3 0 2 2 2
6 2 0 2 2 2
2 3 1
5 3 1
6 9 1
now I want to merge in file3 from the 1st line with col3==0
file3
3 3 3
3 3 3
3 3 3
giving me outputfile2 to look like
outputfile1
2 3 0 2 2 2
6 2 0 2 2 2
2 3 1 3 3 3
5 3 1 3 3 3
6 9 1 3 3 3
Thanks a million for any suggestions offered
Best Regards,
Olga
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to Print starting 3rd line until end of the file. Pls let me know the command.
Thanks in advance. (1 Reply)
Discussion started by: smc3
1 Replies
2. Shell Programming and Scripting
Hi Guys. I have tried the commands sort and join. But I couldn't able to to find the command for joining in a single line based on keys.My example inputs and outputs are like the following.
Help would be appreciated.:D
Input file
a1tabXXXXXXX
a2tabXXXXXXX
a6tabYYYYYYYYY
a71tabXXXXXXX... (7 Replies)
Discussion started by: repinementer
7 Replies
3. Shell Programming and Scripting
Hi Folks,
I got to know from this forums on how to grep from a particular line say line 6
awk 'NR==6 {print;exit}'
But how do i grep from line 6 till the end of the file or command output.
Thanks, (3 Replies)
Discussion started by: Mr. Zer0
3 Replies
4. Shell Programming and Scripting
Hi Guys,
Sorry to bother everyone again here, but I ran into a small problem that has been after me for some time now.
I have a file called file1.txt and has following content -
/folder1/fold/folder 10k
/folder167fold/folder 10MB
/folder2/fold/folder 10G
etc..
etc..
... (1 Reply)
Discussion started by: rockf1bull
1 Replies
5. Shell Programming and Scripting
Hi,
I have two files and i want to merge it like,
file1.txt
---------
abc
cde
efg
file2.txt
-------
111
222
333
Output file should be,
--------------
abc
111 (2 Replies)
Discussion started by: rbalaj16
2 Replies
6. UNIX for Advanced & Expert Users
Hi all,
I'm new in unix. Need some help here.
I have a file called server.cfg which contains the servers name, if I don't want to run on that server, I'll put a "#" infront it.
username1@hostname.com
username2@hostname.com
#username3@hostname.com
#username4@hostname.com... (17 Replies)
Discussion started by: beezy
17 Replies
7. Shell Programming and Scripting
I am new to ksh scripts. I would like to be able to read a file line by line from a certain line number. I have a specific line number saved in a variable, say $lineNumber. How can I start reading the file from the line number saved in $lineNumber? Thanks! (4 Replies)
Discussion started by: dcowboys13
4 Replies
8. Shell Programming and Scripting
Hello,
I'm works on Ubuntu server
My goal : I would like to read file line per line, but i want to started at the end of file.
Currently, I use instructions :
while read line;
do
COMMAND
done < /var/log/apache2/access.log
But, the first line, i don't want this. The file is long... (5 Replies)
Discussion started by: Fuziion
5 Replies
9. UNIX for Dummies Questions & Answers
e.g.
File name: File.txt
cat File.txt
Result:
#INBOUND_QUEUE=FAQ1
INBOUND_QUEUE=FAQ2
I want to get the value for one which is not commented out.
Thanks, (3 Replies)
Discussion started by: Tanu
3 Replies
10. UNIX for Beginners Questions & Answers
I have a file with a list of references towards the end and want to apply a grep for some string.
text ....
@unnumbered References
@sp 1
@paragraphindent 0
2017. @strong{Chalenski, D.A.}; Wang, K.; Tatanova, Maria; Lopez,
Jorge L.; Hatchell, P.; Dutta, P.; @strong{Small airgun... (1 Reply)
Discussion started by: kristinu
1 Replies
MERGE(1) General Commands Manual MERGE(1)
NAME
merge - three-way file merge
SYNOPSIS
merge [ options ] file1 file2 file3
DESCRIPTION
merge incorporates all changes that lead from file2 to file3 into file1. The result ordinarily goes into file1. merge is useful for com-
bining separate changes to an original. Suppose file2 is the original, and both file1 and file3 are modifications of file2. Then merge
combines both changes.
A conflict occurs if both file1 and file3 have changes in a common segment of lines. If a conflict is found, merge normally outputs a
warning and brackets the conflict with <<<<<<< and >>>>>>> lines. A typical conflict will look like this:
<<<<<<< file A
lines in file A
=======
lines in file B
>>>>>>> file B
If there are conflicts, the user should edit the result and delete one of the alternatives.
OPTIONS
-A Output conflicts using the -A style of diff3(1), if supported by diff3. This merges all changes leading from file2 to file3 into
file1, and generates the most verbose output.
-E, -e These options specify conflict styles that generate less information than -A. See diff3(1) for details. The default is -E. With
-e, merge does not warn about conflicts.
-L label
This option may be given up to three times, and specifies labels to be used in place of the corresponding file names in conflict
reports. That is, merge -L x -L y -L z a b c generates output that looks like it came from files x, y and z instead of from files
a, b and c.
-p Send results to standard output instead of overwriting file1.
-q Quiet; do not warn about conflicts.
-V Print RCS's version number.
DIAGNOSTICS
Exit status is 0 for no conflicts, 1 for some conflicts, 2 for trouble.
IDENTIFICATION
Author: Walter F. Tichy.
Manual Page Revision: 5.8.1; Release Date: 2012-06-06.
Copyright (C) 2010-2012 Thien-Thi Nguyen.
Copyright (C) 1990, 1991, 1992, 1993, 1994, 1995 Paul Eggert.
Copyright (C) 1982, 1988, 1989 Walter F. Tichy.
SEE ALSO
diff3(1), diff(1), rcsmerge(1), co(1).
BUGS
It normally does not make sense to merge binary files as if they were text, but merge tries to do it anyway.
GNU RCS 5.8.1 2012-06-06 MERGE(1)