2011-06-07, 18:10
#1
Hej, jag behöver hjälp med att få ut två saker från en html kod. Jag använder programmet Notepad++ och använder replace funktionen.
Html koden:
<tbody>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">22</td>
<td class="city last">PITEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">0</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">SJULSMARK</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">20</td>
<td class="city last">GÄLLIVARE</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">26</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">27</td>
<td class="city last">KALIX</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">21</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">83</td>
<td class="city last">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">24</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">47</td>
<td class="city last">KIRUNA</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">13</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">PITEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">31</td>
<td class="city last">ÖJEBYN</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">16</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">ÖJEBYN</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">45</td>
<td class="city last">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">25</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">KALIX</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">14</td>
<td class="city last">PITEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">49</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">50</td>
<td class="city last">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">24</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">PITEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">21</td>
<td class="city last">GAMMELSTAD</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">8</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">KIRUNA</td>
</tr>
</tbody>
----------------------------------------------------------------------------
Det jag vill ha ut från denna är "Url" och "RegexName".
Jag har kommit fram till denna so far:
Find what: <.*><a href="(.*)" .*>(.*)</a></td>
Replace with: \n \2 \n \1
Jag vill helst kunna göra detta med bara en string (ska göra detta på flera pages (ca 100 st)) eller max två.
Väldigt tacksam för snabba svar!
Html koden:
<tbody>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">22</td>
<td class="city last">PITEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">0</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">SJULSMARK</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">20</td>
<td class="city last">GÄLLIVARE</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">26</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">27</td>
<td class="city last">KALIX</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">21</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">83</td>
<td class="city last">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">24</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">47</td>
<td class="city last">KIRUNA</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">13</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">PITEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">31</td>
<td class="city last">ÖJEBYN</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">16</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">ÖJEBYN</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">45</td>
<td class="city last">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">25</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">KALIX</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">14</td>
<td class="city last">PITEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">49</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">50</td>
<td class="city last">LULEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">24</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">PITEÅ</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="border-left-style: none; border-left-width: initial; border-left-color: initial; "><a href="Url" class="customername">RegexName</a></td>
<td class="distance"><span class="showdistance">Visa</span></td>
<td class="count">21</td>
<td class="city last">GAMMELSTAD</td>
</tr>
<tr class="item Clickable">
<td class="name first" style="background-color: rgb(238, 238, 238); "><a href="Url" class="customername">RegexName</a></td>
<td class="distance" style="background-color: rgb(238, 238, 238); "><span class="showdistance">Visa</span></td>
<td class="count" style="background-color: rgb(238, 238, 238); ">8</td>
<td class="city last" style="background-color: rgb(238, 238, 238); border-right-style: solid; border-right-width: 1px; border-right-color: rgb(221, 221, 221); ">KIRUNA</td>
</tr>
</tbody>
----------------------------------------------------------------------------
Det jag vill ha ut från denna är "Url" och "RegexName".
Jag har kommit fram till denna so far:
Find what: <.*><a href="(.*)" .*>(.*)</a></td>
Replace with: \n \2 \n \1
Jag vill helst kunna göra detta med bara en string (ska göra detta på flera pages (ca 100 st)) eller max två.
Väldigt tacksam för snabba svar!