How to filter non blanks in excel

Hi – I have 20 lines in excel. out of which 10 line items has claim numbers updated and 10 line items are blank. i want to filter only the items which has claim numbers which is non blanks.

i used the below code but it doesnt work can you please help? Urgent

image

This might help you

yourDataTable.Select(“YourColumnName=”"")

yourDataTable.Select(“YourColumnName<>NULL”)

Thanks,
Prankur

2 Likes

@Subram try below statement and check.

pt4v.Select("[CLAIM_NUMBER] IS NOT ‘NULL’")

Thanks - I got the below error
image

Hello @Subram

You can try this

pt4v.select.where(Function(x)Not string.IsNullOrEmpty(x(“CLAIM_NUMBER”).tostring.trim)).CopyToDataTable

Let me know if working.

Hope it Helps :wink:

Datatable.select("[coulmn name]<>’’ ").CopyToDatatable

1 Like