Storetext from a table help to choice correct lines to store

Ui.Vision HowTo
2

I would extract each value, and then check if the length of the string in the 7th column is > 1.

Here is a working test macro

To add:

  • loop ${x} from 2…end to extract all rows
  • store all values in CSV, not just ${c1}

v1:

{
      "Name": "conditional_extract",
      "CreationDate": "2020-1-22",
      "Commands": [
        {
          "Command": "open",
          "Target": "https://www.nonsolocap.it/cap?k=56040",
          "Value": ""
        },
        {
          "Command": "store",
          "Target": "3",
          "Value": "x"
        },
        {
          "Command": "storeText",
          "Target": "xpath=//*[@id=\"po\"]/table/tbody/tr[${x}]/td[1]",
          "Value": "c1"
        },
        {
          "Command": "storeText",
          "Target": "xpath=//*[@id=\"po\"]/table/tbody/tr[${x}]/td[1]",
          "Value": "c2"
        },
        {
          "Command": "storeText",
          "Target": "xpath=//*[@id=\"po\"]/table/tbody/tr[${x}]/td[2]",
          "Value": "c3"
        },
        {
          "Command": "storeText",
          "Target": "xpath=//*[@id=\"po\"]/table/tbody/tr[${x}]/td[3]",
          "Value": "c4"
        },
        {
          "Command": "storeText",
          "Target": "xpath=//*[@id=\"po\"]/table/tbody/tr[${x}]/td[4]",
          "Value": "c5"
        },
        {
          "Command": "storeText",
          "Target": "xpath=//*[@id=\"po\"]/table/tbody/tr[${x}]/td[5]",
          "Value": "c6"
        },
        {
          "Command": "storeText",
          "Target": "xpath=//*[@id=\"po\"]/table/tbody/tr[${x}]/td[6]",
          "Value": "c7"
        },
        {
          "Command": "echo",
          "Target": "This row is ${c1} | ${c2}| ${c3}| ${c4}| ${c5}| ${c6}| ${c7}|",
          "Value": "blue"
        },
        {
          "Command": "if_v2",
          "Target": "${c7}.length > 1",
          "Value": ""
        },
        {
          "Command": "echo",
          "Target": "Now store the line!",
          "Value": "green"
        },
        {
          "Command": "store",
          "Target": "${c1}",
          "Value": "!csvLine"
        },
        {
          "Command": "end",
          "Target": "",
          "Value": ""
        }
      ]
    }