Replace empty cell in the data table

Help Activities
, ,
1

i have data table where some of the cells are empty. I want to write into text box using “Type into” activity for all rows. But i want replace empty cell with [k(tab)] (tab button), please sharing the solution.

image
image933×225 4.86 KB

Thank You

2

Hi, @randa_prakasa

It can be help to you.

The image depicts a UiPath workflow for reading a workbook range, storing it in a DataTable named "dt," and performing conditional actions for each row based on whether specific fields are null or empty. (Captioned by AI)
The image depicts a UiPath workflow for reading a workbook range, storing it in a DataTable named "dt," and performing conditional actions for each row based on whether specific fields are null or empty. (Captioned by AI)1213×677 33.2 KB

The image shows a sequence of UiPath activities with conditional statements checking for null or empty values in the "Age" and "Address" fields of a data row, followed by "Type Into" activities that simulate pressing the Tab key if the conditions are met. (Captioned by AI)
The image shows a sequence of UiPath activities with conditional statements checking for null or empty values in the "Age" and "Address" fields of a data row, followed by "Type Into" activities that simulate pressing the Tab key if the conditions are met. (Captioned by AI)581×531 16.7 KB

3

Hi @randa_prakasa

You can try to use these expression in Type Into activity. Let me know if it works.

if(String.IsNullOrEmpty(CurrentRow("Age").ToString),"[k(tab)]",CurrentRow("Age").ToString)
if(String.IsNullOrEmpty(CurrentRow("Address").ToString),"[k(tab)]",CurrentRow("Address").ToString)

The image shows a UiPath workflow using a "For Each Row in Data Table" activity that inputs "Age" and "Address" data into respective fields if the values are not null or empty. (Captioned by AI)
The image shows a UiPath workflow using a "For Each Row in Data Table" activity that inputs "Age" and "Address" data into respective fields if the values are not null or empty. (Captioned by AI)502×730 22.3 KB

4

thank you so much for the solution

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.