Loading ...
Sorry, an error occurred while loading the content.
 

Re: [Clip] Need help with search and replace clip

Expand Messages
  • Alec Burgess
    casullian_454: I think this should do what you re after: H= Kill first column after URL ^!replace   n?  [0-9,]+  
    Message 1 of 3 , Jun 29, 2003
      casullian_454:

      I think this should do what you're after:

      H="Kill first column after URL"
      ^!replace "</a>\ </td>\n?<td>\ [0-9,]+\ </td>" >>
      "</a>\ </td>\n" rwsa

      Note: It should have been possible to do [0-9,] with [\d,]+ but there is
      some set of circumstance when \d doesn't work that I'm not clear on.

      Regards ... Alec
      --

      ---- Original Message ----
      From: "casullian_454" <casullian_454@...>
      To: <ntb-clips@yahoogroups.com>
      Sent: Sunday, June 29, 2003 16:24
      Subject: [Clip] Need help with search and replace clip

      > I have a HTML table that has 1000 table rows with 6 table data cells
      > per row. I need to remove the 3rd table data cell and its contents
      > for each of these 1000 rows.
      >
      > Here is a snip of the html
      > =============================
      > <tr class="TableRow2">
      > <td> 22 </td>
      > <td> <a target=_blank
      > href="http://www.567.com">http://www.567.com</a> </td>
      > <td> 8,262 </td>
      > <td> 0 </td>
      > <td> 7,064 </td>
      > <td> 89,623 </td>
      >
      > </tr>
      > <tr class="TableRow1">
      > <td> 23 </td>
      > <td> <a target=_blank
      > href="http://www.123.com">http://www.123.com</a> </td>
      > <td> 15,581 </td>
      > <td> 0 </td>
      > <td> 7,054 </td>
      > <td> 250,758 </td>
      >
      > </tr>
      > <tr class="TableRow2">
      > <td> 24 </td>
      > <td> <a target=_blank
      > href="http://www.abc.com">http://www.abc.com</a> </td>
      > <td> 19,143 </td>
      > <td> 0 </td>
      > <td> 7,005 </td>
      > <td> 264,069 </td>
      >
      > </tr>
      > <tr class="TableRow1">
      > <td> 25 </td>
      > <td> <a target=_blank
      > href="http://xyz.com">http://xyz.com</a> </td>
      > <td> 8,010 </td>
      > <td> 0 </td>
      > <td> 6,999 </td>
      > <td> 118,237 </td>
      >
      > </tr>
      > <tr class="TableRow2">
      > <td> 26 </td>
      > <td> <a target=_blank
      > href="http://www.qwerty.com">http://www.qwerty.com</a> </td>
      > <td> 7,765 </td>
      > <td> 0 </td>
      > <td> 6,885 </td>
      > <td> 78,089 </td>
      >
      > </tr>
      > =============================
      >
      >
      >
      > Here is what I need to end up with
      > =============================
      > <tr class="TableRow2">
      > <td> 22 </td>
      > <td> <a target=_blank
      > href="http://www.567.com">http://www.567.com</a> </td>
      > <td> 0 </td>
      > <td> 7,064 </td>
      > <td> 89,623 </td>
      >
      > </tr>
      > <tr class="TableRow1">
      > <td> 23 </td>
      > <td> <a target=_blank
      > href="http://www.123.com">http://www.123.com</a> </td>
      > <td> 0 </td>
      > <td> 7,054 </td>
      > <td> 250,758 </td>
      >
      > </tr>
      > <tr class="TableRow2">
      > <td> 24 </td>
      > <td> <a target=_blank
      > href="http://www.abc.com">http://www.abc.com</a> </td>
      > <td> 0 </td>
      > <td> 7,005 </td>
      > <td> 264,069 </td>
      >
      > </tr>
      > <tr class="TableRow1">
      > <td> 25 </td>
      > <td> <a target=_blank
      > href="http://xyz.com">http://xyz.com</a> </td>
      > <td> 0 </td>
      > <td> 6,999 </td>
      > <td> 118,237 </td>
      >
      > </tr>
      > <tr class="TableRow2">
      > <td> 26 </td>
      > <td> <a target=_blank
      > href="http://www.qwerty.com">http://www.qwerty.com</a> </td>
      > <td> 0 </td>
      > <td> 6,885 </td>
      > <td> 78,089 </td>
      >
      > </tr>
      > =============================
      >
      > Any help would be appreaciated. Removing these rows manually is
      > killing me.
      >
      > Thanks Cas
      >
      >
      > ------------------------ Yahoo! Groups Sponsor
      > ---------------------~--> Looking for the latest Free IT White Papers?
      > Visit SearchSecurity.com to access over 500 white papers.
      > Get instant access at SearchSecurity.com Today
      > http://us.click.yahoo.com/ayjvfD/QLNGAA/uitMAA/dkFolB/TM
      > ---------------------------------------------------------------------~->
      >
      >
      >
      > Your use of Yahoo! Groups is subject to
      > http://docs.yahoo.com/info/terms/
    Your message has been successfully submitted and would be delivered to recipients shortly.