Fill Empty Cell or Delete Row

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

@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

Price.xaml (20.3 KB)

could you please see that

@coder

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

Thanks

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

Well, give me some time

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

Thanks

@coder

You can use Filter Datatable as below

image

Check below

Mark as solution if this helps

Thanks

1 Like

@ksrinu070184 I will try Thanks

Thank you @ksrinu070184 it is work :innocent:

1 Like

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