Check checkboxes based on CSV file input

Ui.Vision HowTo
11

I think the macro in my post above is already the solution.

The only change needed is if the CSV has the checkbox answers in the format of your screenshot:

Type Option 1,
Type Option 2,
Type Option 3,

→ Then you need to parse this CSV row string for the numbers 1,2,… to see if a box needs to be checked.

You could have a logic like “If this string contains 1, then check box 1…” (and so on). You can search the forum for substring parsing to find examples.

So instead of

    {
      "Command": "if",
      "Target": "${a3}==\"check\"",
      "Value": "",
      "Description": ""
    },

you would have a substring check for (in this case) the number 3:

    {
      "Command": "if",
      "Target": "${a3}.lastIndexOf(\"3\") > -1 == true"",
      "Value": "",
      "Description": "check if string contains the number 3"
    },