Traitement fichier html avec awk

GHISLINO Messages postés 214 Date d'inscription   Statut Membre Dernière intervention   -  
dubcek Messages postés 18627 Date d'inscription   Statut Contributeur Dernière intervention   -
Bonjour à tous

j'ai besoin de votre aide pour traiter les éléments ci-dessous SVP:

je possède trois fichiers :

le fichier 1 et 2 contiennent les infos traiter et le 3ème celui à renseigner à partir des 2 premiers fichiers.

Fichier1

unlocked;atermux;TDM;AterMux TP 1[_241];enabled
unlocked;atermux;TDM;AterMux TP 2[_225];enabled

Fichier2

locked;a;TDM;A TP 1;disabled
locked;a;TDM;A TP 2;disabled
locked;a;TDM;A TP 3;disabled
locked;a;TDM;A TP 4;disabled
unlocked;a;STM1;A TP 5;enabled
unlocked;a;STM1;A TP 6;enabled
unlocked;a;STM1;A TP 7;enabled
unlocked;a;STM1;A TP 8;enabled

Pour obtenir le 3 ème fichier on servira des fichiers 1 et 2 les paramètres à modifier sont ceux souligner en GRAS en utilisant les infos du fichier 1et2 matché par les infos AterMux TP 1[_241] et A TP 1
Fichier3 à modifier

<tr height="20">
<td height="81" rowspan="4" bgcolor="#FF0000"><div align="center">locked</div></td>
<td rowspan="4" bgcolor="#FF0000"><div align="center">atermux</div></td>
<td rowspan="4" bgcolor="#FF0000"><div align="center">TDM</div></td>
<td rowspan="4" bgcolor="#FF0000"><div align="center">AterMux TP 1[_241]</div></td>
<td rowspan="4" bgcolor="#FF0000"><div align="center">enabled</div></td>
<td rowspan="4"><div align="center"></div></td>
<td bgcolor="#FF0000"><div align="center">locked</div></td>
<td bgcolor="#FF0000"><div align="center">a</div></td>
<td bgcolor="#FF0000"><div align="center">TDM</div></td>
<td bgcolor="#FF0000"><div align="center">A TP 1</div></td>
<td bgcolor="#FF0000"><div align="center">disabled</div></td>
</tr>
<tr height="20">
<td height="20" bgcolor="#FF0000"><div align="center">locked</div></td>
<td bgcolor="#FF0000"><div align="center">a</div></td>
<td bgcolor="#FF0000"><div align="center">TDM</div></td>
<td bgcolor="#FF0000"><div align="center">A TP 2</div></td>
<td bgcolor="#FF0000"><div align="center">disabled</div></td>
</tr>
<tr height="20">
<td height="20" bgcolor="#FF0000"><div align="center">locked</div></td>
<td bgcolor="#FF0000"><div align="center">a</div></td>
<td bgcolor="#FF0000"><div align="center">TDM</div></td>
<td bgcolor="#FF0000"><div align="center">A TP 3</div></td>
<td bgcolor="#FF0000"><div align="center">disabled</div></td>
</tr>
<tr height="21">
<td height="21" bgcolor="#FF0000"><div align="center">locked</div></td>
<td bgcolor="#FF0000"><div align="center">a</div></td>
<td bgcolor="#FF0000"><div align="center">TDM</div></td>
<td bgcolor="#FF0000"><div align="center">A TP 4</div></td>
<td bgcolor="#FF0000"><div align="center">disabled</div></td>
</tr>
<tr height="20">
<td rowspan="4" height="81"><div align="center">unlocked</div></td>
<td rowspan="4"><div align="center">atermux</div></td>
<td rowspan="4"><div align="center">TDM</div></td>
<td rowspan="4"><div align="center">AterMux TP 2[_225]</div></td>
<td rowspan="4"><div align="center">enabled</div></td>
<td rowspan="4"><div align="center"></div></td>
<td><div align="center">unlocked</div></td>
<td><div align="center">a</div></td>
<td><div align="center">TDM</div></td>
<td><div align="center">A TP 5</div></td>
<td><div align="center">enabled</div></td>
</tr>
<tr height="20">
<td height="20"><div align="center">unlocked</div></td>
<td><div align="center">a</div></td>
<td><div align="center">TDM</div></td>
<td><div align="center">A TP 6</div></td>
<td><div align="center">enabled</div></td>
</tr>
<tr height="20">
<td height="20"><div align="center">unlocked</div></td>
<td><div align="center">a</div></td>
<td><div align="center">TDM</div></td>
<td><div align="center">A TP 7</div></td>
<td><div align="center">enabled</div></td>
</tr>
<tr height="21">
<td height="21"><div align="center">unlocked</div></td>
<td><div align="center">a</div></td>
<td><div align="center">TDM</div></td>
<td><div align="center">A TP 8</div></td>
<td><div align="center">enabled</div></td>
</tr>

Merci d'avance

5 réponses

  1.
    dubcek Messages postés 18627 Date d'inscription   Statut Contributeur Dernière intervention   5 659
     
    hello
    montre le fichier 3 avant et après
    0
  2. GHISLINO Messages postés 214 Date d'inscription   Statut Membre Dernière intervention  
     
    Bjr Dubcek

    le fichier 3 est un fichier template que je souhaiterais modifier avec les info du fichier1 et 2

    ci -dessous le contenu complet du fichier 3.

    Merci d'avance

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <!-- DW6 -->
    <head>
    <!-- Copyright 2005 Macromedia, Inc. All rights reserved. -->
    <title>SUPPORT TYPE BSC-TC-MGM</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link rel="stylesheet" href="mm_travel2.css" type="text/css" />
    <script language="JavaScript" type="text/javascript">
    //--------------- LOCALIZEABLE GLOBALS---------------
    var d=new Date();
    monthname= new Array("Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre");
    //Ensure correct for language. English is "January 1, 2004"
    var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();
    //--------------- END LOCALIZEABLE ---------------
    </script>

    <style type="text/css">
    <!--
    a {
    text-decoration: none;
    }
    //.Style1 {font-size: 18px}
    .Style1 {
    font-size: 18px;
    font-weight: bold;
    }
    .Style2 {font-size: 18px}
    -->
    </style>

    </head>
    <body bgcolor="#C0DFFD">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr bgcolor="#659ca5">
    <td colspan="3" rowspan="2"> </td>
    <td height="63" colspan="3" align="center" valign="bottom" nowrap="nowrap" id="logo"> </td>
    <td width="4"> </td>
    </tr><tr><td colspan="7" bgcolor="#659ca5"> </td>
    </tr>

    <tr>
    <td width="179" valign="top" bgcolor="#E6F3FF">
    <table border="0" cellspacing="0" cellpadding="0" width="175" id="navigation">
    <tr>
    <td width="175"> <br />
    <br /></td>
    </tr>
    <tr>
    <td width="175"><a href="accueil_evenement.html" class="navText">INSTABILITE MIC-RA</a></td>
    </tr>
    <tr>
    <td width="175"><a href="http:///UID-BONDOUKOU">UID-BONDOUKOU</a></td>
    </tr>
    <tr>
    <td width="175"><a href="exemple_affiche_2012.php">UID-GAGNOA</a></td>
    </tr>
    <tr>
    <td width="175"><a href="exemple_affiche_2012.php">UID-KORHOGO</a></td>
    </tr>
    <tr>
    <td width="175"><a href="exemple_affiche_2011.php">UID-MAN</a></td>
    </tr>
    <tr>
    <td width="175"><a href="exemple_affiche_2010.php" class="navText">UIR-ABENGOUROU</a></td>
    </tr>
    <tr>
    <td width="175"><a href="exemple_affiche_2009.php" class="navText">UIR-BOUAKE</a></td>
    </tr>
    <tr>
    <td width="175"><a href="javascript:;" class="navText">UIR-DALOA</a></td>
    </tr>
    <tr>
    <td width="175"><a href="javascript:;" class="navText">UIR-SANPEDRO</a></td>
    </tr>

    <tr>
    <td width="175"><a href="accueil_backup.html" class="navText">UIR-YAMOUSSOUKRO</a></td>
    </tr>
    <tr>
    <td width="175"><a href="accueil_backup.html" class="navText">ZONE1</a></td>
    </tr>
    <tr>
    <td width="175"><a href="accueil_backup.html" class="navText">ZONE2</a></td>
    </tr>
    <tr>
    <td width="175"><a href="accueil_backup.html" class="navText">ZONE3</a></td>
    </tr>
    </table>
    <br />
    <br />
    <br />
    <br /> </td>
    <td width="201"><img src="mm_spacer.gif" alt="" width="50" height="1" border="0" /></td>
    <td colspan="2" valign="top"><img src="mm_spacer.gif" alt="" width="305" height="1" border="0" /><br />
    <br />
    <br />
    <table border="0" cellspacing="0" cellpadding="0" width="552">
    <tr>
    <td width="552" class="pageName"><div align="center"></div></td>
    </tr>

    <tr>
    <td height="26" class="bodyText"><p><a href="indexlogin.html">retour page d'accueil</a></p>
    <p> </p></td>
    </tr>
    </table>
    <p align="center" class="titre Style1"></p>

    <p>

    <html>
    <body>

    <p align="left" class="titre Style1">TYPE DE SUPPORT BSC-TC-MGW</p>

    <p id="EVENEMENTS"><label></label>

    </p>
    <table width="2295" height="27" border="0">
    <tr>

    <FORM action="exemple_affiche_MICRA.php" method="get">

    <div align="left"></div>
    <div align="left"></div>
    <table width="1202" border="0">
    <tr>
    <th width="412" scope="col"><span class="Style2">BSC</span></th>
    <th width="282" scope="col"><span class="Style2">TC</span></th>
    <th width="494" scope="col"><span class="Style2">MGW</span></th>
    </table>

    <div></div>
    <div align="left"></div>
    <table width="1200" border="0">
    <tr>
    <th width="445" height="225" scope="col"><img src="BSC.jpg" alt="BSC" /> </th>
    <th width="222" scope="col"><img src="TC" alt="TC" /></th>
    <th width="519" scope="col"><img src="MSC" alt="MSC" /></th>
    </tr>
    </table>
    <table width="1302" border="0">
    <tr>
    <th width="1210" valign="top" scope="col"><table border="2" cellpadding="0" cellspacing="0">
    <col width="80" span="2" />
    <col width="107" />
    <col width="135" />
    <col width="85" />
    <col width="155" />
    <col width="80" span="3" />
    <col width="134" />
    <col width="88" />
    <tr height="21">
    <td width="89" height="40" bgcolor="#FF6600"><div align="center">Admin State</div></td>
    <td width="62" bgcolor="#FF6600"><div align="center">Interface</div></td>
    <td width="115" bgcolor="#FF6600"><div align="center">Type de support</div></td>
    <td width="174" bgcolor="#FF6600"><div align="center">Atermux</div></td>
    <td width="99" bgcolor="#FF6600"><div align="center">Operat State</div></td>
    <td width="8"><div align="center"></div></td>
    <td width="151" bgcolor="#FF6600"><div align="center">Admin State</div></td>
    <td width="97" bgcolor="#FF6600"><div align="center">Interface</div></td>
    <td width="117" bgcolor="#FF6600"><div align="center">Type de support</div></td>
    <td width="170" bgcolor="#FF6600"><div align="center">Ater</div></td>
    <td width="99" bgcolor="#FF6600"><div align="center">Operat State</div></td>
    </tr>
    <tr height="20">
    <td height="81" rowspan="4" bgcolor=""><div align="center">locked</div></td>
    <td rowspan="4" bgcolor="#FF0000"><div align="center">atermux</div></td>
    <td rowspan="4" bgcolor="#FF0000"><div align="center">TDM</div></td>
    <td rowspan="4" bgcolor="#FF0000"><div align="center">AterMux TP 1[_241]</div></td>
    <td rowspan="4" bgcolor="#FF0000"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td bgcolor="#FF0000"><div align="center">locked</div></td>
    <td bgcolor="#FF0000"><div align="center">a</div></td>
    <td bgcolor="#FF0000"><div align="center">TDM</div></td>
    <td bgcolor="#FF0000"><div align="center">A TP 1</div></td>
    <td bgcolor="#FF0000"><div align="center">disabled</div></td>
    </tr>
    <tr height="20">
    <td height="20" bgcolor="#FF0000"><div align="center">locked</div></td>
    <td bgcolor="#FF0000"><div align="center">a</div></td>
    <td bgcolor="#FF0000"><div align="center">TDM</div></td>
    <td bgcolor="#FF0000"><div align="center">A TP 2</div></td>
    <td bgcolor="#FF0000"><div align="center">disabled</div></td>
    </tr>
    <tr height="20">
    <td height="20" bgcolor="#FF0000"><div align="center">locked</div></td>
    <td bgcolor="#FF0000"><div align="center">a</div></td>
    <td bgcolor="#FF0000"><div align="center">TDM</div></td>
    <td bgcolor="#FF0000"><div align="center">A TP 3</div></td>
    <td bgcolor="#FF0000"><div align="center">disabled</div></td>
    </tr>
    <tr height="21">
    <td height="21" bgcolor="#FF0000"><div align="center">locked</div></td>
    <td bgcolor="#FF0000"><div align="center">a</div></td>
    <td bgcolor="#FF0000"><div align="center">TDM</div></td>
    <td bgcolor="#FF0000"><div align="center">A TP 4</div></td>
    <td bgcolor="#FF0000"><div align="center">disabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 2[_225]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 5</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 6</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 7</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 8</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 3[_242]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 9</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 10</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 11</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 12</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 4[_226]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 13</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 14</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 15</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 16</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 5[_243]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 17</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 18</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 19</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 20</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 6[_227]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 21</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 22</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 23</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 24</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 7[_244]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 25</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 26</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 27</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 28</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 8[_228]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 29</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 30</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 31</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 32</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 9[_245]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 33</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 34</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 35</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 36</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 10[_229]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 37</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 38</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 39</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 40</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 11[_246]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 41</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 42</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 43</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 44</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 12[_230]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 45</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 46</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 47</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">undefined</div></td>
    <td><div align="center">A TP 48</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 13[_247]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 49</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 50</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 51</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 52</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 14[_231]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 53</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 54</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 55</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 56</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 15[_248]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 57</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 58</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 59</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">unlocked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 60</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 16[_232]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">locked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 61</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">locked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 62</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">locked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 63</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">locked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 64</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <td rowspan="4"><div align="center">AterMux TP 17[_249]</div></td>
    <td rowspan="4"><div align="center">enabled</div></td>
    <td rowspan="4"><div align="center"></div></td>
    <td><div align="center">locked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 65</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">locked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 66</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td height="20"><div align="center">locked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 67</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="21">
    <td height="21"><div align="center">locked</div></td>
    <td><div align="center">a</div></td>
    <td><div align="center">TDM</div></td>
    <td><div align="center">A TP 68</div></td>
    <td><div align="center">enabled</div></td>
    </tr>
    <tr height="20">
    <td rowspan="4" height="81"><div align="center">unlocked</div></td>
    <td rowspan="4"><div align="center">atermux</div></td>
    <td rowspan="4"><div align="center">TDM</div></td>
    <b
    0
  3. dubcek Messages postés 18627 Date d'inscription   Statut Contributeur Dernière intervention   5 659
     
    je ne comprends pas vraiment ce qu'il faut modifier 
    <td height="81" rowspan="4" bgcolor="#FF0000"><div align="center">locked</div></td>
    il faut remplacer locked par quoi ?
    0
  4. GHISLINO Messages postés 214 Date d'inscription   Statut Membre Dernière intervention  
     
    Bonsoir Dubcek

    je prends un exemple : dans le fichier 1

    la ligne

    unlocked;atermux;TDM;AterMux TP 1[_241];enabled

    correspond au 4 ligne du fichier2

    locked;a;TDM;A TP 1;disabled
    locked;a;TDM;A TP 2;disabled
    locked;a;TDM;A TP 3;disabled
    locked;a;TDM;A TP 4;disabled

    maintenant dans le fichier 3 il s'agira de rechercher "AterMux TP 1[_241]" dans le fichier3 mettre à jour la ligne contenant le pattern locked ou unlocked selon le cas par l'information contenu dans le fichier 1 champ 1 et faire de même le champ3 et 5

    <tr height="20">
    <td height="81" rowspan="4" bgcolor="#FF0000"><div align="center">locked</div></td>
    <td rowspan="4" bgcolor="#FF0000"><div align="center">atermux</div></td>
    <td rowspan="4" bgcolor="#FF0000"><div align="center">TDM</div></td>
    <td rowspan="4" bgcolor="#FF0000"><div align="center">AterMux TP 1[_241]</div></td>
    <td rowspan="4" bgcolor="#FF0000"><div align="center">enabled</div></td>

    et faire de même dans le fichier 3 pour les lignes comprenant les parttern A TP 1 , A TP 2, A TP3, A TP 4

    merci d'avance
    0

  5. Vous n’avez pas trouvé la réponse que vous recherchez ?

    Posez votre question
  6. dubcek Messages postés 18627 Date d'inscription   Statut Contributeur Dernière intervention   5 659
     
    si j'ai bien compris, essaye ça.
    c'est un peu lourd, awk n'est pas idéal pour traiter du xml 
    $ cat f4.awk
    ARGIND<3 {t[$4]++; t1[$4]=$1; t3[$4]=$3; t5[$4]=$5}
    ARGIND==3 {f[FNR]=$0}
    END {for(l=1; l<=FNR; l++){
    	split(f[l], a, "[<>]");
    	if(t[a[5]]){
    		split(f[l-3], a3, "[<>]"); split(f[l-1], a2, "[<>]"); split(f[l+1], a1, "[<>]");
    		sub(a3[5], t1[a[5]], f[l-3]); sub(a2[5], t3[a[5]], f[l-1]); sub(a1[5], t5[a[5]], f[l+1])
    		}
    	}
    	for(l=1; l<=FNR; l++)print f[l]
    }
    $ awk -F ';' -f f4.awk fichier[123]
    0