Hi @Plankton @Timo @thecoder2012 @ulrich
I’m seaching a solution to store all column from a table is the macro find a value inside a column
I find an example in the forum from @ulrich
Here is a solution:
the macro searches the table for a row with a certain text in the first column (note the ${myrow} variable inside the xpath}, in this line: storeText | /html/body/div[4]/div[1]/div[2]/div[2]/table/tbody/tr[${myrow}]/td[1]"
it extracts text with storeText into a variable, and runs in a loop until the text is found : gotoIf ${text2search}"!="${rowtext}"
then uses the number of the found row to click the right link (“Download@POS=${myrow}”)
ADMIN note 2020/…
But it seem to click incorrect row because it search in first column value 500,000, it find it but after click link of 1,000,000 and not link of 500,000.
In this page the same of @ulrich example i want to store all value in line with value 10,000 in first column what I can create this code ?
Url
If first column contains 10,000 extract all values of this line itherwise do not extract nothing.
Thanks for help
ulrich
January 22, 2020, 5:13pm
2
The solution from here should work, or?
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",
…
Thanks for your code i solved my question
With this command i can check every value in a table and store only interested values
{
"Command": "if_v2",
"Target": "${c7}.length > 1",
"Value": ""
},
Thanks