How to replace a null value with empty string in datatable Varaiable

Help Studio
, ,
1

How to replace a null value with empty string in datatable in UiPath

Legall
Legall819×460 4.27 KB

Please refer the screenshot, i want to replace this NULL value into Empty String in UiPath ACTIVITY

2

@sharu_priya

If its in datatable then use this

  1. For loop on datatable
  2. For loop on column dt.Columns and change type argument to datacolumn
  3. If condition with IsNothing(Currentrow(currentitem)) Or String.Is ullOrEmpty(currentrow(currentitem).ToString.Trim)
  4. Use assign on the then side with currentrow(currentitem) = string.Empty

Cheers

3

Can it be done in SQL Query after selecting the table using RUN COMMAND

4

@sharu_priya

In the select query instead of column name use ISNULL(columnname,’’)

Assuming yours is sql server

Cheers