How to deal with skipping CSV blank cells

How to skip to a Click when the ${!COL9} unit is blank?

Or allow the error to continue to allow the script.

Ask for help

{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div/div[2]/button[2]",
“Value”: “”,
“Targets”: [
"xpath=//
[@id=“content”]/div/div/div[2]/section[4]/div/div[2]/button[2]”,
“xpath=//button[2]”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(1) > div.col-x24.col-l20 > button.btn.listing-editor__quantity-btn.btn–tertiary”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div/div",
“Value”: “”,
“Targets”: [
"xpath=//
[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div/div”,
“xpath=//section[4]/div[2]/div[2]/div/div/div”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(1) > div”
]
},
{
“Command”: “click”,
“Target”: “linkText=Custom”,
“Value”: “”,
“Targets”: [
“linkText=Custom”,
“xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/nav/ul/li[2]/a",
“xpath=//nav/ul/li[2]/a”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > nav > ul > li:nth-child(2) > a”
]
},
{
“Command”: “type”,
“Target”: “id=customSizeInput0”,
“Value”: “{!COL8}", "Targets": [ "id=customSizeInput0", "xpath=//*[@id=\"customSizeInput0\"]", "xpath=//input[@id='customSizeInput0']", "xpath=//li/div/div/input", "css=#customSizeInput0" ] }, { "Command": "click", "Target": "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li/div/div/button", "Value": "", "Targets": [ "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li/div/div/button", "xpath=//li/div/div/button", "css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input--half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li > div > div > button" ] }, { "Command": "type", "Target": "id=customSizeInput1", "Value": "{!COL9}”,
“Targets”: [
“id=customSizeInput1”,
"xpath=//
[@id=“customSizeInput1”]”,
“xpath=//input[@id=‘customSizeInput1’]”,
“xpath=//li[2]/div/div/input”,
“css=#customSizeInput1”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[2]/div/div/button",
“Value”: “”,
“Targets”: [
"xpath=//
[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[2]/div/div/button”,
“xpath=//li[2]/div/div/button”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li:nth-child(2) > div > div > button”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div",
“Value”: “”,
“Targets”: [
"xpath=//
[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div”,
“xpath=//div[2]/div/div[2]/div/div/div/div”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > div”
]
},
{
“Command”: “type”,
“Target”: “id=customSizeInput2”,
“Value”: “{!COL10}", "Targets": [ "id=customSizeInput2", "xpath=//*[@id=\"customSizeInput2\"]", "xpath=//input[@id='customSizeInput2']", "xpath=//li[3]/div/div/input", "css=#customSizeInput2" ] }, { "Command": "click", "Target": "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[3]/div/div/button", "Value": "", "Targets": [ "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[3]/div/div/button", "xpath=//li[3]/div/div/button", "css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input--half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li:nth-child(3) > div > div > button" ] }, { "Command": "click", "Target": "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div", "Value": "", "Targets": [ "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div", "xpath=//div[2]/div/div[2]/div/div/div/div", "css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input--half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > div" ] }, { "Command": "type", "Target": "id=customSizeInput3", "Value": "{!COL11}”,
“Targets”: [
“id=customSizeInput3”,
“xpath=//[@id=“customSizeInput3”]",
“xpath=//input[@id=‘customSizeInput3’]”,
“xpath=//li[4]/div/div/input”,
“css=#customSizeInput3”
]
},
{
“Command”: “click”,
“Target”: "xpath=//
[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[4]/div/div/button”,
“Value”: “”,
“Targets”: [
“xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[4]/div/div/button",
“xpath=//li[4]/div/div/button”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li:nth-child(4) > div > div > button”
]
},
{
“Command”: “click”,
“Target”: "xpath=//
[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div”,
“Value”: “”,
“Targets”: [
“xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div",
“xpath=//div[2]/div/div[2]/div/div/div/div”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > div”
]
},
{
“Command”: “type”,
“Target”: “id=customSizeInput4”,
“Value”: “${!COL112}”,
“Targets”: [
“id=customSizeInput4”,
"xpath=//
[@id=“customSizeInput4”]”,
“xpath=//input[@id=‘customSizeInput4’]”,
“xpath=//li[5]/div/div/input”,
“css=#customSizeInput4”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[5]/div/div/button",
“Value”: “”,
“Targets”: [
"xpath=//
[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[5]/div/div/button”,
“xpath=//li[5]/div/div/button”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li:nth-child(5) > div > div > button”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div[2]/button",
“Value”: “”,
“Targets”: [
"xpath=//
[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div[2]/button”,
“xpath=//div/div/div[2]/button”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.form__actions.br–none > button”
]
},

If you want the macro to continue running after an error occurs, you can add
Store | true | !ErrorIgnore
To see if everything is running ok you could check with an if for the variable !StatusOK

Very simple solution with if, if value have 0 number of characthers do not execute action

   {
      "Command": "if_v2",
      "Target": "${!COL9}.length == 0",
      "Value": ""
    },
    {
      "Command": "comment",
      "Target": "Do Nothing",
      "Value": ""
    },
    {
      "Command": "end",
      "Target": "",
      "Value": ""
    },