Enter null value in text box

I am trying to read values from the excel sheet and entering it into the text field. If the excel row has some value, then the previous text value is cleared using Empty Field, and new value is entered.
But if the value in the excel sheet is blank, then the value is not cleared and the previous value is left as is.

If the value in excel sheet is blank then I want to clear the field and save the record.


There are multiple solutions for this

(a) Is there a Reset option/button on the form which u can click before you enter the data ?
(b) Is it possible for you to clear all the controls before you start data entry ?
(c) If row(“Phone”).toString.length() == 0 then clear the field
and then Typeinto …