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

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

Expand Messages
  • Larry Thomas
    Hi Cas, ... Please hurry and try this clip. I really would not like to have you pass away on the list ‡-[ H= RemoveLine3 ;lrt e¿ê ;06/29/2003, 03:52:40
    Message 1 of 3 , Jun 29, 2003
      Hi Cas,

      At 08:24 PM 6/29/03 -0000, you wrote:
      >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>
      >
      >Snip<
      >
      >=============================
      >
      >Any help would be appreaciated. Removing these rows manually is
      >killing me.
      >
      >Thanks Cas

      Please hurry and try this clip. I really would not like to have you pass
      away on the list ‡-[

      H="RemoveLine3"
      ;lrt e¿ê
      ;06/29/2003, 03:52:40 PM
      ^!Jump 1
      :Loop
      ^!Find "href=" AIST
      ^!IfError Exit ELSE Next
      ^!Jump +1
      ^!DeleteLine
      ^!Goto Loop

      Regards,

      lrt e¿ê
    • casullian_454
      ... you pass ... Hey Larry tahks. I get to live. ;-) To get it to work, I had to copy the table to another page by itself as there was other urls on the page
      Message 2 of 3 , Jun 29, 2003
        > Please hurry and try this clip. I really would not like to have
        you pass
        > away on the list ‡-[
        >
        > H="RemoveLine3"
        > ;lrt e¿ê
        > ;06/29/2003, 03:52:40 PM
        > ^!Jump 1
        > :Loop
        > ^!Find "href=" AIST
        > ^!IfError Exit ELSE Next
        > ^!Jump +1
        > ^!DeleteLine
        > ^!Goto Loop
        >
        > Regards,
        >
        > lrt e¿ê



        Hey Larry tahks. I get to live. ;-)

        To get it to work, I had to copy the table to another page by itself
        as there was other urls on the page and turn off word wraping. With
        word wraping on it did some funky stuff.

        A quick cut and paste into a new file, turn off word wrap and run
        then copy and paste back to original file, turn word wrap back on.
        Less than a minute.

        I'm a happy camper. Cas
      • Alec Burgess
        casullian_454: I think this should do what you re after: H= Kill first column after URL ^!replace   n?  [0-9,]+  
        Message 3 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.