How to insert the content of a file into another file?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to insert the content of a file into another file?
# 1  
Old 01-05-2017
How to insert the content of a file into another file?

I have the two files. And i want the each line of first file to be inserted in the beginning of second file each line and the final output should be like this. Could anyone help me on this?
Code:
cat file1
1
2
3
4

Code:
cat file2
text1
text2
text3
text4

final_output
Code:
1 text1
2 text2
3 text3
4 text4


Last edited by Scrutinizer; 01-05-2017 at 06:48 AM.. Reason: code tags
# 2  
Old 01-05-2017
Code:
paste file1 file2

Code:
$ awk 'NR==FNR{a[NR]=$0;next}{print a[FNR],$0}' file1 file2
1 text1
2 text2
3 text3
4 text4

This User Gave Thanks to itkamaraj For This Post:
# 3  
Old 01-05-2017
Thanks for the solution given. Its works fine. But my exact requirement is, i am having one <td> data in one file and i want to inset that into another file within the <tr> tag. Could you please help me on this.

file1
Code:
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>

file2
Code:
<tr><td>text1</td></tr>
<tr><td>text2</td></tr>
<tr><td>text3</td></tr>
<tr><td>text4</td></tr>

output
Code:
<tr><td>1</td><td>text1</td></tr>
<tr><td>2</td><td>text2</td></tr>
<tr><td>3</td><td>text3</td></tr>
<tr><td>4</td><td>text4</td></tr>

# 4  
Old 01-05-2017
Hello thomasraj87,

Could you please try following, not tested with many permutations and combinations though.
Code:
awk 'FNR==NR{A[FNR]=$0;next} {gsub(/<tr>|<\/tr>/,"")} {print "<tr>" A[FNR] $0 "</tr>"}'   Input_file

Thanks,
R. Singh
# 5  
Old 01-05-2017
With the fine working examples by itkamaraj, how would YOU tackle the NEW problem? BTW, wouldn't it have been nice to post the real samples in the first place, saving your and our time?
These 2 Users Gave Thanks to RudiC For This Post:
# 6  
Old 01-05-2017
Another awk approach:
Code:
awk '{p=$0} getline<f>0{$1=$1 p}1' FS='<td>' OFS='<td>' f=file2 file1

# 7  
Old 01-05-2017
Dear R. Singh,
It works well and getting the desired output. In some very rare case, my sql is giving more than one <tr> tag as output in the same line as given below.

For ex: file2
Code:
<tr><td>text1</td></tr>
<tr><td>text2</td></tr><tr><td>txt2</td></tr>
<tr><td>text3</td></tr><tr><td>txt3</td></tr><tr><td>txt4</td></tr>
<tr><td>text4</td></tr>

In this case if i use this awk command, some <tr> tags are missing as given below.
Code:
awk 'FNR==NR{A[FNR]=$0;next} {gsub(/<tr>|<\/tr>/,"")} {print "<tr>" A[FNR] $0 "</tr>"}'   file1 file2
<tr><td>1</td><td>text1</td></tr>
<tr><td>2</td><td>text2</td><td>txt2</td></tr>
<tr><td>3</td><td>text3</td><td>txt3</td><td>txt4</td></tr>
<tr><td>4</td><td>text4</td></tr>

In this case, how can i insert my <td> tag from file1 into file2 as first <td> tag independent of how many <tr> tags are present in same line in file2.

Desired output:
Code:
<tr><td>1</td><td>text1</td></tr>
<tr><td>2</td><td>text2</td></tr><tr><td>txt2</td></tr>
<tr><td>3</td><td>text3</td></tr><tr><td>txt3</td></tr><tr><td>txt4</td></tr>
<tr><td>4</td><td>text4</td></tr>


Last edited by thomasraj87; 01-05-2017 at 11:06 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Insert content from file 1 to file 2 in specific criteria meet

Hi , I'm looking for some code that can copy and paste form file1 to file2 with 2 criterial meet. file1: test "sp-j1" test "sp-j2" test "sp-j3" test "sp-j4" file2: sub Pre_Shorts1 (Status_Code, Message$) global Status !if Message$ <> "" then print... (3 Replies)
Discussion started by: kttan
3 Replies

2. Shell Programming and Scripting

Insert content of a file right after pattern in another file

suppose i have original file: original.txt: hello how are you you are wonderful what time is it I went to the store last night. and some apple juice then i have another file: anotherfile.txt: with my friends mary, john and harry. We had a great time. We bought food Suppose... (1 Reply)
Discussion started by: SkySmart
1 Replies

3. Shell Programming and Scripting

Insert content of file before the first occurrence of a line starts with a pattern in another file

Hi all, I'm new to scripting.. facing some problems while inserting content of a file into another file... I want to insert content of a file (file2) into file1, before first occurrence of "line starts with pattern" in file1 file1 ====== working on linux its unix world working on... (14 Replies)
Discussion started by: Jagadeesh Kumar
14 Replies

4. Shell Programming and Scripting

Insert content of a file to another file at a line number which is given by third file

Hi friends, here is my problem. I have three files like this.. cat file1.txt ======= unix is best unix is best linux is best unix is best linux is best linux is best unix is best unix is best cat file2.txt ======== Windows performs better Mac OS performs better Windows... (4 Replies)
Discussion started by: Jagadeesh Kumar
4 Replies

5. Shell Programming and Scripting

Insert content of a file into another file before given pattern

I need to insert file x2 into x1 right before first BBB line. $ cat x1 AAA 1 AAA 2 AAA 3 BBB 1 BBB 2 BBB 3 $ cat x2 XXX - insert 1 XXX - insert 2 I need to get AAA 1 AAA 2 AAA 3 XXX - insert 1 XXX - insert 2 BBB 1 (2 Replies)
Discussion started by: migurus
2 Replies

6. Programming

[SQL] Insert content file to mysql

dear all, i want to insert string in file to mysql i just want how to do that cause i am poor in sql languages ... so this file like this DATA.txt doni|student|westjava|123412|lombok| iwan|student|westjava|1234412|utankayu| rio|student|westjava|12342|cempedak| so i want insert DATA.txt to... (2 Replies)
Discussion started by: zvtral
2 Replies

7. Shell Programming and Scripting

Insert content of a file after a certain line in another file

Hi, it's my first post to this forum. I just started bash and I'm stuck at one issue. I want to include content of a file in another file after a certain line. I'm using sed for inserting one line but how to insert all content of a file ? For example i have a file list.txt with a few lines and... (4 Replies)
Discussion started by: ktm
4 Replies

8. Shell Programming and Scripting

extract content from a file and insert to another file

please help for the following task... I have to extract the mac address & IP address from the file1: ... 0100004512EEF4 03 192.168.0.7 192.168.0.1 -1 ... 0100779hF5D212 03 192.168.0.8 192.168.0.1 -1 ... 0100789lF5D212 03 192.168.0.9 192.168.0.1 -1 ... ... change the format (addidng... (15 Replies)
Discussion started by: fredao
15 Replies

9. Shell Programming and Scripting

Insert file content via sed after two searchings

Hi folks, The file webcache.xml contains a lot sections which begins and ends with the string </CACHEABILITYRULE>. The section In need to deel with is: </CACHEABILITYRULE> <CACHEABILITYRULE NAME="cache swf" CACHE="YES" COMMENT="This rule caches all .swf files. This... (2 Replies)
Discussion started by: nir_s
2 Replies
Login or Register to Ask a Question