insert file2 after line containing patternX in file1


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting insert file2 after line containing patternX in file1
# 1  
Old 04-16-2008
insert file2 after line containing patternX in file1

file1:-
aaaa
bbbb
cccc
dddd
eeee

file2:-
1111
2222
3333
4444

I want to insert file2 after pattern bbbb to come up with a finished file of :-
aaaa
bbbb
1111
2222
3333
4444
cccc
dddd
eeee

I have it working using grep-n/head/tail but it looks horrible.

thoughts?
# 2  
Old 04-17-2008
HI.

There is a sed sub-command to insert a file:
Code:
       r filename
              Append text read from filename.
-- excerpt from man sed

See if you can create a complete sed command to find the appropriate line in the first file and use "r" to get the second file inserted at that point ... cheers, drl
# 3  
Old 04-17-2008
ok i found something that works.

ed -s file1 <<< $'/bbbb/ r file2\n,p' # to stdout
or
ed -s file1 <<< $'/bbbb/ r file2\n,w' # to directly update file1

results in the output being:-
aaaa
bbbb
1111
2222
3333
4444
cccc
dddd
eeee

which is much neater than what i had, however now i would like to have the file names as variables as per :-
f1=file1
f2=file2
ed -s $f1 <<< $'/bbbb/ r $f2\n,p'

which results in :-
?$f2

ie not resolving the $f2 variable.... so i changed the quotes to doubles :-
$ ed -s $f1 <<< $"/bbbb/ r $f2\n,p"
?file2\n,p

so its resolving $f2 but failing syntax in ed for some reason...

anyone know how to resolve this?
# 4  
Old 04-17-2008
sigh, wish i had checked sed first....

$ sed "/bbbb/ r $f2" < $f1
aaaa
bbbb
1111
2222
3333
4444
cccc
dddd
eeee


The last step is to get the file inserted BEFORE the pattern..... using sed, if my pattern is bbbb can i get the output to look like ?? :-
aaaa
1111
2222
3333
4444
bbbb
cccc
dddd
eeee

Last edited by repudi8or; 04-17-2008 at 12:43 AM..
# 5  
Old 04-18-2008
Hi.

As you likely know, you would need some kind of memory to be able to insert before a specific line. The memory would contain the line of interest, you would cause the second file to be inserted, and then you would cause the line of interest to be printed.

There is a basic memory facility in sed. It's called the hold space (to differentiate it from the normal pattern space).

Have you tried to use that yet? ... cheers, drl
# 6  
Old 04-18-2008
Code:
f1=file1
f2=file2

ed -s $f1 <<EOF
/bbb/r $f2
w
q
EOF

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to search field2 in file2 using range of fields file1 and using match to another field in file1

I am trying to use awk to find all the $2 values in file2 which is ~30MB and tab-delimited, that are between $2 and $3 in file1 which is ~2GB and tab-delimited. I have just found out that I need to use $1 and $2 and $3 from file1 and $1 and $2of file2 must match $1 of file1 and be in the range... (6 Replies)
Discussion started by: cmccabe
6 Replies

2. UNIX for Dummies Questions & Answers

Compare file1 and file2, print matching lines in same order as file1

I want to print only the lines in file2 that match file1, in the same order as they appear in file 1 file1 file2 desired output: I'm getting the lines to match awk 'FNR==NR {a++}; FNR!=NR && a' file1 file2 but they are in sorted order, which is not what I want: Can anyone... (4 Replies)
Discussion started by: pathunkathunk
4 Replies

3. Shell Programming and Scripting

Match single line in file1 to groups of lines in file2

I have two files. File 1 is a two-column index file, e.g. comp11084_c0_seq6:130-468(-) comp12746_c0_seq3:140-478(+) comp11084_c0_seq3:201-539(-) comp12746_c0_seq2:191-529(+) File 2 is a sequence file with headers named with the same terms that populate file 1. ... (1 Reply)
Discussion started by: pathunkathunk
1 Replies

4. Shell Programming and Scripting

Compare file1 for matching line in file2 and print the difference in matching lines

Hello, I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Discussion started by: RasB15
2 Replies

5. Shell Programming and Scripting

Using regex's from file1, print line and line after matches in file2

Good day, I have a list of regular expressions in file1. For each match in file2, print the containing line and the line after. file1: file2: Output: I can match a regex and print the line and line after awk '{lines = $0} /Macrosiphum_rosae/ {print lines ; print lines } ' ... (1 Reply)
Discussion started by: pathunkathunk
1 Replies

6. Shell Programming and Scripting

look for line from FILE1 at FILE2

Hi guys! I'm trying to write something to find each line of file1 into file2, if line is found return YES, if not found return NO. The result can be written to a new file. Can you please help me out? FILE1 INPUT: WATER CAR SNAKE (in reality this file has about 600 lines each with a... (2 Replies)
Discussion started by: demmel
2 Replies

7. UNIX for Dummies Questions & Answers

if matching strings in file1 and file2, add column from file1 to file2

I have very limited coding skills but I'm wondering if someone could help me with this. There are many threads about matching strings in two files, but I have no idea how to add a column from one file to another based on a matching string. I'm looking to match column1 in file1 to the number... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

8. Shell Programming and Scripting

[Solved] delete line from file1 by reading from file2

Hi All, I have to arrange one of the text file by deleting specific lines. cat file1.txt 3595 3595 -0.00842773 -0.0085077 0.00368851 12815 12815 -0.00929239 0.00439785 0.0291697 3747 3747 -0.00974353 0.00228922 0.0225058 3574 3574 -0.00711399 -0.00315748 0.0141206 .... 12734... (7 Replies)
Discussion started by: senayasma
7 Replies

9. Shell Programming and Scripting

append text from file1 to the end of each line in file2

hi; my file2.txt:portname=1;list=10.11;l- portname=2;list=10.12;l- portname=3;list=10.13;l- ... my file1.txt:;"{'sector=%27'}"\&> so; i want to see:portname=1;list=10.11;l-;"{'sector=%27'}"\&> portname=2;list=10.12;l-;"{'sector=%27'}"\&> portname=3;list=10.13;l-;"{'sector=%27'}"\&>... (4 Replies)
Discussion started by: gc_sw
4 Replies

10. Shell Programming and Scripting

Compare multiple fields in file1 to file2 and print line and next line

Hello, I have two files that I need to compare and print out the line from file2 that has the first 6 fields matching the first 6 fields in file1. Complicating this are the following restrictions 1. file1 is only a few thousand lines at most and file2 is greater than 2 million 2. I need to... (7 Replies)
Discussion started by: gillesc_mac
7 Replies
Login or Register to Ask a Question