Is there anyway to assign to empty value ( if it is empty in queue) to variable?

We are capturing values from PDF and store into excel then add to queue
Sometimes the captured values might be NULL (like below screenshot)

image

We are clicking different element in website if the value is NULL…

But we unable to assign the empty value to variable.
Is there anyway to assign to empty value ( if it is empty in queue) to variable?
Please find the error below

Hi @Sathish_Kumar_S ,

In the assign Activity you can First Check if the Value is Nothing, meaning if it is null, then Assign Nothing or the Value itself like below :

Delivery = if(item.SpecificContent("Delivery") is Nothing, Nothing,item.SpecificContent("Delivery").ToString)

image

Still getting same error

Hi

Nothing method would help here to validate null value in a queue item

Mention like this
Delivery = if(item.SpecificContent(“Delivery”) is Nothing, String.Empty,item.SpecificContent(“Delivery”).ToString)

Cheers @Sathish_Kumar_S

Still facing same issue

@Sathish_Kumar_S , Please do Check the Line Mentioned above, we do not use .ToString

Remove .ToString and give a try

@Sathish_Kumar_S

1 Like

I am facing the same issue and it is not working…

I do had similar problem and I did some not the best way but worked for me. First I assign value (like ‘Delivery’) where it may contains nothing(Null) to a variable “your_variable_name”. Then I used “IF” activity to check if (your_variable_name=“”) in Then I added again the Assign activity with “your_varible_name” and assign “0” to it. So now the output will be 0 if there is nothing.