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 

}