Use Xpath to get all the rows of a table after a specific row in Automation Anywhere












0















I am trying to get the values of all the row after a specific row(This specific row can be identified using id) using xpath. Kindly note that i am using it in automation anywhere's object cloning command to locate and fetch the details.
lets say this is the table:



<table class="actiontable" >

<tbody>

<tr></tr>

<tr></tr>

<tr id="h32423">

<td class="claim"><span id="claimants">Claimants</span></td>

</tr>

<tr id="a23">

<td id="g543"><a href="some site">Edward Hunter</a> </td>

</tr>

<tr>

<td id="g544"><a href="some site">Jane Doe</a> </td>

</tr>

<tr></tr>

</tbody>

</table>


Here in the above table I need to fetch all the name after the Claimants row. Any suggestions?






xpath automationanywhere







share|improve this question


















  • 1





    Show what you've tried

    – Andersson
    Nov 15 '18 at 8:19











  • I used the below one but it brings every <tr> , but i want what is after claimants //table[@class="actionTable"]/descendant::tr

    – g444ran
    Nov 15 '18 at 9:25













  • Check answer i update your XPath

    – Amrendra Kumar
    Nov 15 '18 at 9:34
















0















I am trying to get the values of all the row after a specific row(This specific row can be identified using id) using xpath. Kindly note that i am using it in automation anywhere's object cloning command to locate and fetch the details.
lets say this is the table:



<table class="actiontable" >

<tbody>

<tr></tr>

<tr></tr>

<tr id="h32423">

<td class="claim"><span id="claimants">Claimants</span></td>

</tr>

<tr id="a23">

<td id="g543"><a href="some site">Edward Hunter</a> </td>

</tr>

<tr>

<td id="g544"><a href="some site">Jane Doe</a> </td>

</tr>

<tr></tr>

</tbody>

</table>


Here in the above table I need to fetch all the name after the Claimants row. Any suggestions?






xpath automationanywhere







share|improve this question


















  • 1





    Show what you've tried

    – Andersson
    Nov 15 '18 at 8:19











  • I used the below one but it brings every <tr> , but i want what is after claimants //table[@class="actionTable"]/descendant::tr

    – g444ran
    Nov 15 '18 at 9:25













  • Check answer i update your XPath

    – Amrendra Kumar
    Nov 15 '18 at 9:34














0












0








0








I am trying to get the values of all the row after a specific row(This specific row can be identified using id) using xpath. Kindly note that i am using it in automation anywhere's object cloning command to locate and fetch the details.
lets say this is the table:



<table class="actiontable" >

<tbody>

<tr></tr>

<tr></tr>

<tr id="h32423">

<td class="claim"><span id="claimants">Claimants</span></td>

</tr>

<tr id="a23">

<td id="g543"><a href="some site">Edward Hunter</a> </td>

</tr>

<tr>

<td id="g544"><a href="some site">Jane Doe</a> </td>

</tr>

<tr></tr>

</tbody>

</table>


Here in the above table I need to fetch all the name after the Claimants row. Any suggestions?






xpath automationanywhere







share|improve this question














I am trying to get the values of all the row after a specific row(This specific row can be identified using id) using xpath. Kindly note that i am using it in automation anywhere's object cloning command to locate and fetch the details.
lets say this is the table:



<table class="actiontable" >

<tbody>

<tr></tr>

<tr></tr>

<tr id="h32423">

<td class="claim"><span id="claimants">Claimants</span></td>

</tr>

<tr id="a23">

<td id="g543"><a href="some site">Edward Hunter</a> </td>

</tr>

<tr>

<td id="g544"><a href="some site">Jane Doe</a> </td>

</tr>

<tr></tr>

</tbody>

</table>


Here in the above table I need to fetch all the name after the Claimants row. Any suggestions?






xpath automationanywhere




xpath automationanywhere






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 15 '18 at 7:36









g444rang444ran

11




11








  • 1





    Show what you've tried

    – Andersson
    Nov 15 '18 at 8:19











  • I used the below one but it brings every <tr> , but i want what is after claimants //table[@class="actionTable"]/descendant::tr

    – g444ran
    Nov 15 '18 at 9:25













  • Check answer i update your XPath

    – Amrendra Kumar
    Nov 15 '18 at 9:34














  • 1





    Show what you've tried

    – Andersson
    Nov 15 '18 at 8:19











  • I used the below one but it brings every <tr> , but i want what is after claimants //table[@class="actionTable"]/descendant::tr

    – g444ran
    Nov 15 '18 at 9:25













  • Check answer i update your XPath

    – Amrendra Kumar
    Nov 15 '18 at 9:34








1




1





Show what you've tried

– Andersson
Nov 15 '18 at 8:19





Show what you've tried

– Andersson
Nov 15 '18 at 8:19













I used the below one but it brings every <tr> , but i want what is after claimants //table[@class="actionTable"]/descendant::tr

– g444ran
Nov 15 '18 at 9:25







I used the below one but it brings every <tr> , but i want what is after claimants //table[@class="actionTable"]/descendant::tr

– g444ran
Nov 15 '18 at 9:25















Check answer i update your XPath

– Amrendra Kumar
Nov 15 '18 at 9:34





Check answer i update your XPath

– Amrendra Kumar
Nov 15 '18 at 9:34












3 Answers
3






active

oldest

votes


















0














You need to check the preceding-sibling data like this:



//tr[preceding-sibling::tr[normalize-space(.)='Claimants']]


You can try this as per your comment:



/table[@class='actiontable']/descendant::tr[normalize-space(lower-case(.))!= 'claimants']





share|improve this answer

































    0














    For your simple example you can do the following in the Automation Anywhere editor:



    Add a loop command with a Times condition of 2



    Inside the loop object clone one of the fields you want to access and change the DOMXPath to



    /html/body/table[1]/tbody[1]/tr[$Counter$+3]/td[1]/a[1]


    Select Action to be Get Property and Select Property to HTML InnerText
    Assign this to a variable of your choice



    Output this variable via a message box command



    When run you should then see displayed the two names.



    In this we are using the AA counter variable to iterate through the DOMXPath. I have adjusted it by 3 as there are 3 <tr> tags before the row you wish to start on






    share|improve this answer
























    • The problem is it is not always 2. The number of rows after claimants varies dynamically. So I cannot iterate it 2 times, all the time.

      – g444ran
      Nov 15 '18 at 9:44











    • As mentioned this was for your simple example. You have a few strategies you can follow to get the count. a) Clone the table and get the total rows (you will need to adjust this to get the starting position b) change the loop to a condition and then wrap the object cloning in an error handler in which you set your condition. This means it will loop through all the rows until it doesn't work and then exit the loop

      – Dohsan
      Nov 15 '18 at 9:52



















    0














    I'm not sure whether it's too late to answer or not. I think the following XPath match your condition.



    //tr[td[span[@id='claimants']]]/following-sibling::tr/td/a



    *You can change /tr/td/a to /tr or /tr/td according to which element you want to access



    I try this XPath in XPath Search console on Google Chrome and it navigate to all a tags after the row which has ID = claimants.



    As I'm quite new to AA, I don't know how to loop through those a tags getting from the XPath. But I hope this help you solve the problem. :)



    [Update] I found the solution

    1. Using //tr[td[span[@id='claimants']]] with Object Cloning to get the index of the specific row. Let's say the index value is stored in variable $vIndex$

    2. Loop through all td in the table

    3. If the $Counter$ > $vIndex$ THEN that is the row under the specific row.






    share|improve this answer

























      Your Answer






      StackExchange.ifUsing("editor", function () {
      StackExchange.using("externalEditor", function () {
      StackExchange.using("snippets", function () {
      StackExchange.snippets.init();
      });
      });
      }, "code-snippets");

      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "1"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });














      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53314467%2fuse-xpath-to-get-all-the-rows-of-a-table-after-a-specific-row-in-automation-anyw%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      3 Answers
      3






      active

      oldest

      votes








      3 Answers
      3






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      0














      You need to check the preceding-sibling data like this:



      //tr[preceding-sibling::tr[normalize-space(.)='Claimants']]


      You can try this as per your comment:



      /table[@class='actiontable']/descendant::tr[normalize-space(lower-case(.))!= 'claimants']





      share|improve this answer






























        0














        You need to check the preceding-sibling data like this:



        //tr[preceding-sibling::tr[normalize-space(.)='Claimants']]


        You can try this as per your comment:



        /table[@class='actiontable']/descendant::tr[normalize-space(lower-case(.))!= 'claimants']





        share|improve this answer




























          0












          0








          0







          You need to check the preceding-sibling data like this:



          //tr[preceding-sibling::tr[normalize-space(.)='Claimants']]


          You can try this as per your comment:



          /table[@class='actiontable']/descendant::tr[normalize-space(lower-case(.))!= 'claimants']





          share|improve this answer















          You need to check the preceding-sibling data like this:



          //tr[preceding-sibling::tr[normalize-space(.)='Claimants']]


          You can try this as per your comment:



          /table[@class='actiontable']/descendant::tr[normalize-space(lower-case(.))!= 'claimants']






          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 15 '18 at 9:33

























          answered Nov 15 '18 at 9:18









          Amrendra KumarAmrendra Kumar

          1,1541311




          1,1541311

























              0














              For your simple example you can do the following in the Automation Anywhere editor:



              Add a loop command with a Times condition of 2



              Inside the loop object clone one of the fields you want to access and change the DOMXPath to



              /html/body/table[1]/tbody[1]/tr[$Counter$+3]/td[1]/a[1]


              Select Action to be Get Property and Select Property to HTML InnerText
              Assign this to a variable of your choice



              Output this variable via a message box command



              When run you should then see displayed the two names.



              In this we are using the AA counter variable to iterate through the DOMXPath. I have adjusted it by 3 as there are 3 <tr> tags before the row you wish to start on






              share|improve this answer
























              • The problem is it is not always 2. The number of rows after claimants varies dynamically. So I cannot iterate it 2 times, all the time.

                – g444ran
                Nov 15 '18 at 9:44











              • As mentioned this was for your simple example. You have a few strategies you can follow to get the count. a) Clone the table and get the total rows (you will need to adjust this to get the starting position b) change the loop to a condition and then wrap the object cloning in an error handler in which you set your condition. This means it will loop through all the rows until it doesn't work and then exit the loop

                – Dohsan
                Nov 15 '18 at 9:52
















              0














              For your simple example you can do the following in the Automation Anywhere editor:



              Add a loop command with a Times condition of 2



              Inside the loop object clone one of the fields you want to access and change the DOMXPath to



              /html/body/table[1]/tbody[1]/tr[$Counter$+3]/td[1]/a[1]


              Select Action to be Get Property and Select Property to HTML InnerText
              Assign this to a variable of your choice



              Output this variable via a message box command



              When run you should then see displayed the two names.



              In this we are using the AA counter variable to iterate through the DOMXPath. I have adjusted it by 3 as there are 3 <tr> tags before the row you wish to start on






              share|improve this answer
























              • The problem is it is not always 2. The number of rows after claimants varies dynamically. So I cannot iterate it 2 times, all the time.

                – g444ran
                Nov 15 '18 at 9:44











              • As mentioned this was for your simple example. You have a few strategies you can follow to get the count. a) Clone the table and get the total rows (you will need to adjust this to get the starting position b) change the loop to a condition and then wrap the object cloning in an error handler in which you set your condition. This means it will loop through all the rows until it doesn't work and then exit the loop

                – Dohsan
                Nov 15 '18 at 9:52














              0












              0








              0







              For your simple example you can do the following in the Automation Anywhere editor:



              Add a loop command with a Times condition of 2



              Inside the loop object clone one of the fields you want to access and change the DOMXPath to



              /html/body/table[1]/tbody[1]/tr[$Counter$+3]/td[1]/a[1]


              Select Action to be Get Property and Select Property to HTML InnerText
              Assign this to a variable of your choice



              Output this variable via a message box command



              When run you should then see displayed the two names.



              In this we are using the AA counter variable to iterate through the DOMXPath. I have adjusted it by 3 as there are 3 <tr> tags before the row you wish to start on






              share|improve this answer













              For your simple example you can do the following in the Automation Anywhere editor:



              Add a loop command with a Times condition of 2



              Inside the loop object clone one of the fields you want to access and change the DOMXPath to



              /html/body/table[1]/tbody[1]/tr[$Counter$+3]/td[1]/a[1]


              Select Action to be Get Property and Select Property to HTML InnerText
              Assign this to a variable of your choice



              Output this variable via a message box command



              When run you should then see displayed the two names.



              In this we are using the AA counter variable to iterate through the DOMXPath. I have adjusted it by 3 as there are 3 <tr> tags before the row you wish to start on







              share|improve this answer












              share|improve this answer



              share|improve this answer










              answered Nov 15 '18 at 9:36









              DohsanDohsan

              2768




              2768













              • The problem is it is not always 2. The number of rows after claimants varies dynamically. So I cannot iterate it 2 times, all the time.

                – g444ran
                Nov 15 '18 at 9:44











              • As mentioned this was for your simple example. You have a few strategies you can follow to get the count. a) Clone the table and get the total rows (you will need to adjust this to get the starting position b) change the loop to a condition and then wrap the object cloning in an error handler in which you set your condition. This means it will loop through all the rows until it doesn't work and then exit the loop

                – Dohsan
                Nov 15 '18 at 9:52



















              • The problem is it is not always 2. The number of rows after claimants varies dynamically. So I cannot iterate it 2 times, all the time.

                – g444ran
                Nov 15 '18 at 9:44











              • As mentioned this was for your simple example. You have a few strategies you can follow to get the count. a) Clone the table and get the total rows (you will need to adjust this to get the starting position b) change the loop to a condition and then wrap the object cloning in an error handler in which you set your condition. This means it will loop through all the rows until it doesn't work and then exit the loop

                – Dohsan
                Nov 15 '18 at 9:52

















              The problem is it is not always 2. The number of rows after claimants varies dynamically. So I cannot iterate it 2 times, all the time.

              – g444ran
              Nov 15 '18 at 9:44





              The problem is it is not always 2. The number of rows after claimants varies dynamically. So I cannot iterate it 2 times, all the time.

              – g444ran
              Nov 15 '18 at 9:44













              As mentioned this was for your simple example. You have a few strategies you can follow to get the count. a) Clone the table and get the total rows (you will need to adjust this to get the starting position b) change the loop to a condition and then wrap the object cloning in an error handler in which you set your condition. This means it will loop through all the rows until it doesn't work and then exit the loop

              – Dohsan
              Nov 15 '18 at 9:52





              As mentioned this was for your simple example. You have a few strategies you can follow to get the count. a) Clone the table and get the total rows (you will need to adjust this to get the starting position b) change the loop to a condition and then wrap the object cloning in an error handler in which you set your condition. This means it will loop through all the rows until it doesn't work and then exit the loop

              – Dohsan
              Nov 15 '18 at 9:52











              0














              I'm not sure whether it's too late to answer or not. I think the following XPath match your condition.



              //tr[td[span[@id='claimants']]]/following-sibling::tr/td/a



              *You can change /tr/td/a to /tr or /tr/td according to which element you want to access



              I try this XPath in XPath Search console on Google Chrome and it navigate to all a tags after the row which has ID = claimants.



              As I'm quite new to AA, I don't know how to loop through those a tags getting from the XPath. But I hope this help you solve the problem. :)



              [Update] I found the solution

              1. Using //tr[td[span[@id='claimants']]] with Object Cloning to get the index of the specific row. Let's say the index value is stored in variable $vIndex$

              2. Loop through all td in the table

              3. If the $Counter$ > $vIndex$ THEN that is the row under the specific row.






              share|improve this answer






























                0














                I'm not sure whether it's too late to answer or not. I think the following XPath match your condition.



                //tr[td[span[@id='claimants']]]/following-sibling::tr/td/a



                *You can change /tr/td/a to /tr or /tr/td according to which element you want to access



                I try this XPath in XPath Search console on Google Chrome and it navigate to all a tags after the row which has ID = claimants.



                As I'm quite new to AA, I don't know how to loop through those a tags getting from the XPath. But I hope this help you solve the problem. :)



                [Update] I found the solution

                1. Using //tr[td[span[@id='claimants']]] with Object Cloning to get the index of the specific row. Let's say the index value is stored in variable $vIndex$

                2. Loop through all td in the table

                3. If the $Counter$ > $vIndex$ THEN that is the row under the specific row.






                share|improve this answer




























                  0












                  0








                  0







                  I'm not sure whether it's too late to answer or not. I think the following XPath match your condition.



                  //tr[td[span[@id='claimants']]]/following-sibling::tr/td/a



                  *You can change /tr/td/a to /tr or /tr/td according to which element you want to access



                  I try this XPath in XPath Search console on Google Chrome and it navigate to all a tags after the row which has ID = claimants.



                  As I'm quite new to AA, I don't know how to loop through those a tags getting from the XPath. But I hope this help you solve the problem. :)



                  [Update] I found the solution

                  1. Using //tr[td[span[@id='claimants']]] with Object Cloning to get the index of the specific row. Let's say the index value is stored in variable $vIndex$

                  2. Loop through all td in the table

                  3. If the $Counter$ > $vIndex$ THEN that is the row under the specific row.






                  share|improve this answer















                  I'm not sure whether it's too late to answer or not. I think the following XPath match your condition.



                  //tr[td[span[@id='claimants']]]/following-sibling::tr/td/a



                  *You can change /tr/td/a to /tr or /tr/td according to which element you want to access



                  I try this XPath in XPath Search console on Google Chrome and it navigate to all a tags after the row which has ID = claimants.



                  As I'm quite new to AA, I don't know how to loop through those a tags getting from the XPath. But I hope this help you solve the problem. :)



                  [Update] I found the solution

                  1. Using //tr[td[span[@id='claimants']]] with Object Cloning to get the index of the specific row. Let's say the index value is stored in variable $vIndex$

                  2. Loop through all td in the table

                  3. If the $Counter$ > $vIndex$ THEN that is the row under the specific row.







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited Jan 10 at 9:45

























                  answered Jan 10 at 8:11









                  Pandarian LdPandarian Ld

                  1621520




                  1621520






























                      draft saved

                      draft discarded




















































                      Thanks for contributing an answer to Stack Overflow!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid …



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53314467%2fuse-xpath-to-get-all-the-rows-of-a-table-after-a-specific-row-in-automation-anyw%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      -

                      Popular posts from this blog

                      Bressuire

                      Image
                      Subprefecture and commune in Nouvelle-Aquitaine, France Bressuire Subprefecture and commune Chateau de Bressuire and the Eglise Notre-Dame Coat of arms Location of Bressuire Bressuire Show map of France Bressuire Show map of Nouvelle-Aquitaine Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Country France Region Nouvelle-Aquitaine Department Deux-Sèvres Arrondissement Bressuire Canton Bressuire Government  • Mayor .mw-parser-output .nobold{font-weight:normal} (2014–20) Jean Michel Bernier Area 1 180.59 km 2 (69.73 sq mi) Population (2014) 2 19,300  • Density 110/km 2 (280/sq mi) Time zone UTC+01:00 (CET)  • Summer (DST) UTC+02:00 (CEST) INSEE/Postal code 79049 /79300 Elevation 98–236 m (322–774 ft) (avg. 173 m or 568 ft) 1 French Land Register data, which exclude...
                      Read more

                      Vorschmack

                      Image
                      Vorschmack Ukrainian Jewish-style vorschmack served on rye bread Course Hors d'oeuvre Region or state Eastern Europe Associated national cuisine Ashkenazi Jewish, Finnish, German, Ukrainian, Polish, Russian Main ingredients Ground meat and/or fish Cookbook: Vorschmack   Media: Vorschmack Vorschmack or forshmak (Yiddish: פֿאָרשמאַק ‎, from archaic German Vorschmack , "foretaste" [1] or "appetizer" [2] ) is an originally East European dish made of salty minced fish or meat. Different variants of this dish are especially common in Ashkenazi Jewish and Finnish cuisine. Some varieties are also known in Russian and Polish cuisine. Contents 1 In Jewish cuisine 2 In Russian cuisine 3 In Polish cuisine 4 In Finnish cuisine 5 See also 6 References In Jewish cuisine According to Gil Marks, the German name points to the possible Germanic origin of this dish. [1] William Pokhlyobkin descr...
                      Read more

                      Quarantine

                      Image
                      For other uses, see Quarantine (disambiguation). Signal flag "Lima" called the "Yellow Jack" which when flown in harbor means ship is under quarantine. A simple yellow flag (also called the "Yellow Jack") had historically been used to signal quarantine (it stands for Q among signal flags), but now indicates the opposite, as a signal of a ship free of disease that requests boarding and inspection. A quarantine is used to separate and restrict the movement of people; it is 'a restraint upon the activities or communication of persons or the transport of goods designed to prevent the spread of disease or pests', for a certain period of time. [1] This is often used in connection to disease and illness, such as those who may possibly have been exposed to a communicable disease. [2] The term is often erroneously used to mean medical isolation, which is "to separate ill persons who have a communicable disease from those who are healthy...
                      Read more