How to check the column is sorted or not

[Amit Dengale]

Hi,

I have a table with 4 columns. I wanted to check if the 2nd column is alphabetically sorted or not?

Is there any keyword in robot to check this? If no can anyone please help me how to do it?

--

Thanks,

Amit

[Kevin O.]

Seems like there ought to be a keyword in Collections for that...

If you can get the columnar values into a list you can copy, sort, can compare it. Here's an example:

    @{actual}=    Create List    alpha    bravo    charlie

    @{sorted}=    Copy List    ${actual}

    Sort List    ${sorted}

    Lists Should Be Equal    ${actual}    ${sorted}

    @{actual}=    Create List    bravo    alpha    charlie

    @{sorted}=    Copy List    ${actual}

    Sort List    ${sorted}

    Run Keyword And Expect Error    Lists are different:*    Lists Should Be Equal    ${actual}    ${sorted}

Kevin

[Amit Dengale]

Amit Dengale <aden...@gmail.com>

Thanks for your reply Kevin. Sorry for the late reply.

Here my problem is that I am not getting the text values of all the rows in the list.

eg. this is how I get the individual text values 

Get Text    xpath=//*[@id="accountsTabPanel"]/*[@id="accountsTabPanel-body"]/div[contains(@id,"partnergrid-")]//table/tbody/tr[1]/td[2]

    Get Text    xpath=//*[@id="accountsTabPanel"]/*[@id="accountsTabPanel-body"]/div[contains(@id,"partnergrid-")]//table/tbody/tr[2]/td[2]

..

..

    Get Text    xpath=//*[@id="accountsTabPanel"]/*[@id="accountsTabPanel-body"]/div[contains(@id,"partnergrid-")]//table/tbody/tr[n]/td[2]

 

how should I get all the text values in the list?

 

Kevin Ormbrek

This method is slow and fills up the logs a bit, but is reasonable for small tables.

 

${cnt}=    Get Matching Xpath Count    //*[@id="accountsTabPanel"]/*[@id="accountsTabPanel-body"]/div[contains(@id,"partnergrid-")]//table/tbody/tr/td[2]

${values}=    Create List

:FOR    ${i}    IN RANGE    1    ${cnt} + 1

...    ${value}=    Get Text    xpath=(//*[@id="accountsTabPanel"]/*[@id="accountsTabPanel-body"]/div[contains(@id,"partnergrid-")]//table/tbody/tr/td[2])[${i}]

...    Append To List    ${values}    ${value}

Amit Dengale <aden...@gmail.com>

Thanks Kevin, It works like a charm.

I just changed (...) by (\) in the for loop.

I will update the post with this solution.