Traitement fichier html avec awk

Fermé
GHISLINO Messages postés 214 Date d'inscription lundi 25 juillet 2011 Statut Membre Dernière intervention 8 décembre 2023 - 14 juil. 2014 à 13:17
dubcek Messages postés 18749 Date d'inscription lundi 15 janvier 2007 Statut Contributeur Dernière intervention 29 septembre 2024 - 15 juil. 2014 à 15:22
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























A voir également:

5 réponses

dubcek Messages postés 18749 Date d'inscription lundi 15 janvier 2007 Statut Contributeur Dernière intervention 29 septembre 2024 5 618
14 juil. 2014 à 14:32
hello
montre le fichier 3 avant et après
0
GHISLINO Messages postés 214 Date d'inscription lundi 25 juillet 2011 Statut Membre Dernière intervention 8 décembre 2023
Modifié par GHISLINO le 14/07/2014 à 15:53
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
dubcek Messages postés 18749 Date d'inscription lundi 15 janvier 2007 Statut Contributeur Dernière intervention 29 septembre 2024 5 618
14 juil. 2014 à 16:04
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
GHISLINO Messages postés 214 Date d'inscription lundi 25 juillet 2011 Statut Membre Dernière intervention 8 décembre 2023
14 juil. 2014 à 16:57
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

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

Posez votre question
dubcek Messages postés 18749 Date d'inscription lundi 15 janvier 2007 Statut Contributeur Dernière intervention 29 septembre 2024 5 618
15 juil. 2014 à 15:22
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