Fill Empty Cell or Delete Row

[coder]

Hi ,

I need help to fill empty cell or delete the row , i have price column and it has some empty cell i try to fill that or delete row

this what i do but it is not working

there is any error ?

or how i can delete row which has empty cell

Thanks

[Srini84 (Srinivas Kadamati)]

@coder

String.IsNullOrEmpty(row(“price”).ToString) → This will return the empty cells

Again in Else you are checking for a " ", May i know your logic if it is Else?

Share a sample data and required one

Thanks

[coder]

Price.xaml (20.3 KB)

could you please see that

[Srini84 (Srinivas Kadamati)]

@coder

Can you tell me where you are getting issue, some sample data as well as your expected output

Thanks

[coder]

The else if because i have values like this $99.44$99.88 so it is delete the $ and give me the first number

[coder]

Well, give me some time

[coder]

I mean like this . there are some empty cell , i want to fill empty with 0 value or delete the row

Thanks

[Srini84 (Srinivas Kadamati)]

@coder

You can use Filter Datatable as below

Check below

Mark as solution if this helps

Thanks

[coder]

@Srini84 I will try Thanks

[coder]

Thank you @Srini84 it is work