Xpath to select particular cell in a table depending on the other column text in the same row

Question

I have a HTML table with some columns and rows.

There is a row in the table with the text "Name" in column 2 and the text "crm" in column 4. I would like to select the Checkbox from this row and the Checkbox is in column 1.

But there is an another row with the text "Name" in column 2 and the text "escr" in column 4. I also have 2 rows with text "Address" in the same format.

I would like to select the checkbox where column 2 has text "Name" and column 4 has text "crm"

How can I build the XPath to get the correct checkbox?

I have an Xpath started, it gets all the rows where column 4 has the text "crm"

//table[@id="data_configuration_mappings_ct_fields_body"]//tr//td//div//span[text()="crm"]

I have also tried the following XPath, it does not work.

//table[@id="data_configuration_mappings_ct_fields_body"]//tr[.//div[text()="crm"] and .//div[text()="Name"]]//input

the HTML is (if scroll to the middle the 2 Name text is there):


    
    
    
        
            
                
            
        
        
            
                Address
            
        
        
            
                Address
            
        
        
            
                crm
            
        
        
            
                Main
            
        
        
            
                ADD1 + ADD2 + ADD3 + ADD4 + PCODE
            
        
        
            
                CRM
            
        
        
            
                DM
            
        
        
            
                
            
        
    
    
        
            
                
            
        
        
            
                Phone
            
        
        
            
                Phone
            
        
        
            
                crm
            
        
        
            
                Main
            
        
        
            
                PHONE
            
        
        
            
                CRM
            
        
        
            
                DM
            
        
        
            
                
            
        
    
    
        
            
                
            
        
        
            
                ACVSEQ
            
        
        
            
                ACVSEQ
            
        
        
            
                crm
            
        
        
            
                Main
            
        
        
            
                MOBILE + TITLE
            
        
        
            
                CRM
            
        
        
            
                DM
            
        
        
            
                
            
        
    
    
        
            
                
            
        
        
            
                DOB
            
        
        
            
                DOB
            
        
        
            
                crm
            
        
        
            
                Main
            
        
        
            
                DOB
            
        
        
            
                CRM
            
        
        
            
                DM
            
        
        
            
                
            
        
    
    
        
            
                
            
        
        
            
                Name
            
        
        
            
                Name
            
        
        
            
                crm
            
        
        
            
                Main
            
        
        
            
                TITLE + FNAME + SNAME + GENDER
            
        
        
            
                CRM
            
        
        
            
                DM
            
        
        
            
                
            
        
    
    
        
            
                
            
        
        
            
                Name
            
        
        
            
                Name
            
        
        
            
                escr
            
        
        
            
                Main
            
        
        
            
                TITLE + FNAME + SNAME + GENDER
            
        
        
            
                ESCR
            
        
        
            
                DM

Thanks,

Riaz Ladhani · Accepted Answer

I have just managed to work it out. I have constructed the following Xpath:

//table[@id="data_configuration_mappings_ct_fields_body"]//tr//td//div//span[text()="crm"]/ancestor::tr[1]//td[2]//div//span[text()="Name"]/ancestor::tr[1]/td[1]//input[@type="checkbox"]

First locate the text "crm" anywhere within the tr, td, div and span tag.
Then using the axis ancestor select all ancestors of the current node, in col2 and locate the text "Name"
Then using the axis ancestor select all ancestors of the current node, in col1 locate the input field of type checkbox

Xpath to select particular cell in a table depending on the other column text in the same row

Answers (1)

Related Questions