merging content of two files using sed or awk

mukherjee_debajyoti · 11-27-2009, 07:46 AM

Hi
I have two files file_1 and file_2.
The contents of the two files are as shown below :

file_1
-------

Name : <Data>
Gender : <Data>
Age : <Blank , no data in this field>
Designation : <Data>

file_2
--------

Name : <Data.
Age : <Data>

The requirement is , i need to cut the Age value from file_2 and paste it to the Age field of file_1 for each and every Name.

Please provide me the solution of the problem.
(Sed or Awk anyone is OK for me)

Thanks,
Debajyoti

sycamorex · 11-27-2009, 07:56 AM

Welcome to LQ.

What have you done so far to solve this problem?

mukherjee_debajyoti · 11-29-2009, 11:34 PM

Quote:

Originally Posted by sycamorex

Welcome to LQ.

What have you done so far to solve this problem?

Hi ,
Please find the details as give below

File 1 :

Name : xx
Gender : Male
Age :
Designation : Engineer

Name : yy
Gender : Male
Age :
Designation : Manager

Name : zz
Gender : Male
Age :
Designation : Lead

File 2 :

Name : xx
Age : 28

Name : yy
Age : 30

Name : zz
Age : 40

I was trying to use awk NR==FNR{} commands to merge the contents of File_1 and File_2 to a new file File 3
But i was not getting the desired result as per my requirement

Please help me to get rid of the issue

Thanks
Debajyoti

P.S: Content of File 3 will be as shown below

Name : xx
Gender : Male
Age : 28
Designation : Engineer

Name : yy
Gender : Male
Age : 30
Designation : Manager

Name : zz
Gender : Male
Age :40
Designation : Lead

ghostdog74 · 11-30-2009, 02:19 AM

bash 4

Code:

#!/bin/bash
declare -A names
while IFS=" : " read -r key value
do
    
    case "$key" in
        "" ) continue;;
        Name*) names["$value"]="";n=$value;;
        Age*) names["$n"]=$value;;       
            
    esac   
done <"file2"

while IFS=" : " read -r k v
do
    case "$k" in
        "" ) continue;;        
        Age*)
            echo "$k : ${names[$n]}";;
        Name*) n=$v ;;&
        *) echo "$k : $v";;
    esac               
done <"file1"

Sergei Steshenko · 11-30-2009, 03:35 AM

Quote:

Originally Posted by mukherjee_debajyoti

Hi ,
Please find the details as give below

File 1 :

Name : xx
Gender : Male
Age :
Designation : Engineer

Name : yy
Gender : Male
Age :
Designation : Manager

Name : zz
Gender : Male
Age :
Designation : Lead

File 2 :

Name : xx
Age : 28

Name : yy
Age : 30

Name : zz
Age : 40

I was trying to use awk NR==FNR{} commands to merge the contents of File_1 and File_2 to a new file File 3
But i was not getting the desired result as per my requirement

Please help me to get rid of the issue

Thanks
Debajyoti

P.S: Content of File 3 will be as shown below

Name : xx
Gender : Male
Age : 28
Designation : Engineer

Name : yy
Gender : Male
Age : 30
Designation : Manager

Name : zz
Gender : Male
Age :40
Designation : Lead

And why should this be done using 'sed' or 'awk' ?

AnanthaP · 11-30-2009, 05:43 AM

'awk' and 'sed' are two progs commonly available on most *nixes and so are probably easiest to start with.

In awk, I would stuff data from the first file into hashes (associative arrays) using name as the key and "" for the age.

When I encounter second file data, I would read the name and update the age into the hash.

Finally (on END), I would output the hash.

End