Find/replace Value: I want to find empty cellls in a excel file and replace with 0

Help Activities
, ,
#1

Hi! I want to find the empty cells in a excel file and replace it with a 0, but i don’t know what to put in the Value to find.

image

Thx for your answers

#2

Main.xaml (9.2 KB)
Test1.xlsx (8.8 KB)
Here are the excel and xaml file im using.

#3

as you are lookin for “” Empty string it will not catch a space
The provided Excel contains space on the cellls which are looking blank

it is risky but you can try

  • first run - replace " " with “”
  • second run - replace “” with 0

When doing this on Datatable level, then you would have a better control on it, as you can use the trim method and would not harm spaces within texts

#4

Hi @Ismael

Here is the workflow

Main.xaml (10.2 KB)

image
image420×717 15.4 KB

Regards
Gokul

3 Likes
#5

i try with " “;”";0;“0”. Didn’t work, ty

#6

this work, thank u!

1 Like
#7

Great @Ismael

If you don’t have any query , Kindly mark the post as solved

Regards
Gokul

#8

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