Need to replace with blank if the field has the value "none"

[Anived_Mishra]

Hi, all when the robot is reading the excel field “family discount, please list relationship” if it is “none” it should make it blank before adding it to the queue. What do I need to change in my expression editor?

Regards
Anived

[Nithinkrishna]

Hey @Anived_Mishra

I’m just assuming you are looping through Excel rows,

in_TxItem("colName") = in_TxItem("colName").ToString.Replace("-- None --", String.Empty)

Thanks
#nK

[Anived_Mishra]

Thank you for your response. I am getting this error.

[Nithinkrishna]

Hey @Anived_Mishra

You shouldn’t be using in the condition prop, instead it should be used inside the IF block !

Thanks
#nK