Appending content of a file to another file before a specific character


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Appending content of a file to another file before a specific character
# 1  
Old 02-14-2019
Appending content of a file to another file before a specific character

Hi there,

i've got a file with this content

Code:
[matt@matt01 tmp]$ cat file1
Matt
Mar

The other file has the same number of lines with this content:
Code:
[matt@matt01 tmp]$ cat file2
20404=767294
23450=32427

is there a way with either using sed, awk or paste to insert the content of file1 before the "=" character? So I'll end up with this:
Code:
20404_Matt=767294
23450_Mar=32427

--- Post updated at 06:29 PM ---

I have found a workaround with paste and awk

Code:
paste -d "=" file1 file2 | awk -F "=" '{print$2"("$1")="$3}'

# 2  
Old 02-14-2019
Code:
awk -F= 'FNR==NR{f1[FNR]=$0;next} {print $1 "_" f1[FNR], $2}' file1 OFS="=" file2

This User Gave Thanks to vgersh99 For This Post:
# 3  
Old 02-14-2019
Code:
awk '(getline tmp < "file1") { print $1 "_" tmp FS $2}' FS="=" file2

This User Gave Thanks to nezabudka For This Post:
# 4  
Old 02-14-2019
Code:
awk '!/=/ {line[FNR]="_"$0} /=/ && $1=$1 line[FNR]' file1 FS== OFS== file2

Login or Register to Ask a Question

Previous Thread | Next Thread

10 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

Count specific character of a file in each line and delete this character in a specific position

I will appreciate if you help me here in this script in Solaris Enviroment. Scenario: i have 2 files : 1) /tmp/TRANSACTIONS_DAILY_20180730.txt: 201807300000000004 201807300000000005 201807300000000006 201807300000000007 201807300000000008 2)... (10 Replies)
Discussion started by: teokon90
10 Replies

3. Shell Programming and Scripting

Appending newline character End of File

Hi Gurus, Need help. I'm a beginner in Unix. I have a requirement, need to add or append newline (\n) character in file. Sample Data: 1|Main|Test|~# 2|Main|Hello|~# 3|Main|Unix|~# 4|Main|File|~#Output: 1|Main|Test|~# 2|Main|Hello|~# 3|Main|Unix|~# 4|Main|File|~#\n -- append only... (13 Replies)
Discussion started by: Gouri Solleti
13 Replies

4. Shell Programming and Scripting

Bash - Appending to specific line in file

I'm working on a personal project, a multiplication quiz script for my kids. In it, the user's performance will be recorded and written to a file. After they've played it a little while, it will start to focus more on the ones that give them the most trouble-- that take a long time to answer or... (4 Replies)
Discussion started by: treesloth
4 Replies

5. Shell Programming and Scripting

Appending file content

how to append the contents of filel to the contents of file2?. i.e. file1: 1 2 3 file2: 4 5 6 then the file2 shoud be 4 5 6 1 2 (7 Replies)
Discussion started by: shashwat2691
7 Replies

6. Shell Programming and Scripting

read the text file and print the content character by character..

hello all i request you to give the solution for the following problem.. I want read the text file.and print the contents character by character..like if the text file contains google means..i want to print g go goo goog googl google like this Using unix Shell scripting... without using... (1 Reply)
Discussion started by: samupnl
1 Replies

7. Shell Programming and Scripting

appending content in a xml file

Please help me on this..... i have a file which has following content: <IPCoreProducerConfig> <Producer> <config> <key>machineId</key> <value>machine1</value> </config> <config> ... (4 Replies)
Discussion started by: Aditya.Gurgaon
4 Replies

8. Shell Programming and Scripting

To remove the newline character while appending into a file

Hi All, We append the output of a file's size in a file. But a newline character is appended after the variable. Pls help how to clear this. filesize=`ls -l test.txt | awk `{print $5}'` echo File size of test.txt is $filesize bytes >> logfile.txt The output we got is, File size of... (4 Replies)
Discussion started by: amio
4 Replies

9. AIX

find for specific content in file in the directory and list only file names

Hi, I am trying to find the content of file using grep and find command and list only the file names but i am getting entire file list of files in the directory find . -exec grep "test" {} \; -ls Can anyone of you correct this (2 Replies)
Discussion started by: madhu_Jagarapu
2 Replies

10. Shell Programming and Scripting

Reading specific contents from a file and appending it to another file

Hi, I need to write a shell script (ksh) to read contents starting at a specific location from one file and append the contents at specific location in another file. Please find below the contents of the source file that I need to read the contents from, File 1 -----# more... (5 Replies)
Discussion started by: dnicky
5 Replies
Login or Register to Ask a Question