[SOLVED] Sed command issue

Issue

I have this file inside a mariaDB that looks like this

name    callerid    secret  context type    host
1000    Omar Al-Ani <1000>  op1000DIR   MANAGEMENT  friend  dynamic 
1001    Ammar Zigderly <1001>   1001    MANAGEMENT  peer    dynamic 
1002    Lubna COO Office <1002>     1002    ELdefault   peer    dynamic

i want to convert it using sed and awk to look like this format

[1000]
        callerid=Omar Al-Ani <1000>
        secret=op1000DIR
        context=MANAGEMENT
        type=friend
        host=dynamic
[1001]
        callerid=Ammar Zigderly <1001>
        secret=1001
        context=MANAGEMENT
        type=peer
        host=dynamic

[1002]
        callerid=Lubna COO Office <1002>
        secret=1002
        context=ELdefault
        type=peer
        host=dynamic

This is the output of this command head -3 filename | od -c on the input file

  0000000   n   a   m   e  \t   c   a   l   l   e   r   i   d  \t   s   e
0000020   c   r   e   t  \t   c   o   n   t   e   x   t  \t   t   y   p
0000040   e  \t   h   o   s   t  \n   1   0   0   0      \t   O   m   a
0000060   r       A   l   -   A   n   i       <   1   0   0   0   >    
0000100  \t   o   p   1   0   0   0   D   I   R      \t   M   A   N   A
0000120   G   E   M   E   N   T  \t   f   r   i   e   n   d  \t   d   y
0000140   n   a   m   i   c      \n   1   0   0   1      \t   A   m   m
0000160   a   r       Z   i   g   d   e   r   l   y       <   1   0   0
0000200   1   >      \t   1   0   0   1      \t   M   A   N   A   G   E
0000220   M   E   N   T  \t   p   e   e   r  \t   d   y   n   a   m   i
0000240   c      \n
0000243

Any idea would be helpfull !

Solution

I think awk is going to be a bit simpler and easier (?) to modify if requirements change:

awk -F'\t' '

BEGIN { labels[2]="callerid"
        labels[3]="secret"
        labels[4]="context"
        labels[5]="type"
        labels[6]="host"
      }

FNR>1 { gsub(/ /,"",$1)                             # remove spaces from 1st column
        printf "[%s]\n",$1
        for (i=2;i<=6;i++)
            printf "\t%s=%s\n", labels[i],$i
        print ""
      }
' names.dat

This generates:

[1000]
        callerid=Omar Al-Ani <1000>
        secret=op1000DIR
        context=MANAGEMENT
        type=friend
        host=dynamic

[1001]
        callerid=Ammar Zigderly <1001>
        secret=1001
        context=MANAGEMENT
        type=peer
        host=dynamic

[1002]
        callerid=Lubna COO Office <1002>
        secret=1002
        context=ELdefault
        type=peer
        host=dynamic

Answered By - markp-fuso

Answer Checked By - Pedro (WPSolving Volunteer)