China DOS Union

Original structure of file a.ini:
<p1:Item>
<p1:Key>CBP_514_SMDB</p1:Key>
<p1:Type>Database</p1:Type>
<p1:Database>
<p1:Type>SMDB</p1:Type>
<p1:SMDB>
<p1:Host>10.71.110.175</p1:Host>
<p1:Protocol>TELNET</p1:Protocol>
<p1:Port>23</p1:Port>
<p1:UID>smdb13</p1:UID>
<p1:PWD>bGu7HJLDe7ib5QI0WJia2g==</p1:PWD>
<p1:SysomcUID/>
<p1:SysomcPWD>qmrOF5nY34i8yYrXmljISQ==</p1:SysomcPWD>
</p1:SMDB>
</p1:Database>
</p1:Item>

Target structure:
<p1:Item>
<p1:Key>CBP_514_SMDB</p1:Key>
<p1:Type>Database</p1:Type>
<p1:Database>
<p1:Type>SMDB</p1:Type>
<p1:SMDB>
<p1:Host>10.71.110.175</p1:Host>
<p1:Protocol>TELNET</p1:Protocol>
<p1:Port>23</p1:Port>
<p1:Protocol2>FTP</p1:Protocol2>
<p1:Port2>21</p1:Port2>
<p1:UID>smdb13</p1:UID>
<p1:PWD>bGu7HJLDe7ib5QI0WJia2g==</p1:PWD>
<p1:SysomcUID/>
<p1:SysomcPWD>qmrOF5nY34i8yYrXmljISQ==</p1:SysomcPWD>
</p1:SMDB>
</p1:Database>
</p1:Item>

That is, add the following two lines:
<p1:Protocol2>FTP</p1:Protocol2>
<p1:Port2>21</p1:Port2>

Conditions for adding them:
There are many item entries with this kind of structure in a.ini. Only entries whose <p1:Type> is SMDB should get them added. If those two lines already exist in the item itself, then they do not need to be added either.

Many thanks

[ Last edited by w61655 on 2010-9-20 at 09:47 ]

Use gawk to do it,

BEGIN{ftp_flag=0;smdb_flag=0}{ if ($0 ~ "<p1:Item>") { print $0 getline line print line while (line !~ "</p1:Item>") { getline line print line while (line ~ "<p1:Type>SMDB</p1:Type>") { getline line print line while (line !~ "</p1:SMDB>") { smdb_flag=1 lines=line getline line row++ if (line ~ "<p1:Protocol2>FTP</p1:Protocol2>" || line ~ "<p1:Protocol2>SFTP</p1:Protocol2>") { ftp_flag=1 } } if(smdb_flag=1) { for(i=1;i<row;i++) { print lines if(lines ~ "<p1:Port>" && ftp_flag==0) { print "<p1:Protocol2>FTP</p1:Protocol2>" print "<p1:Port2>21</p1:Port2>" } } print line ftp_flag=0 smdb_flag=0 delete lines row=0 } } } next } print $0 }