How to filter non blanks in excel

[Subram (SubramRPA)]

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

[PrankurJoshi]

This might help you

yourDataTable.Select(“YourColumnName=”“”)

yourDataTable.Select(“YourColumnName<>NULL”)

I need to filter datatable for blanks

I have a datatable that has a status column. This column starts blank and once the first action is taken it is marked as found or not found. I want to be able filter the status column by blanks/null/empty but have been unsuccessful so far. i am using dtInvoiceNum.Select(“Status=Null”) to create an array of datarows and then doing a for each in the array.

I need to filter out the blank from datatable which column is datetime type

My Excel file data show below [image] Then I do read range to keep data into DT1 variable datatable type (with header selected) And I do read cell to get column name of column 2 which is datetime type, it is 12-May-18. Keep into Header variable string type I have created the datarow type variable called DTrow1 After that I use Assign activity to do select datatable, propose to remove row 4 and 5 because of it contain blank data. I assigned DTrow1 in the left side and DT1.Select(Header+" <>‘…

Thanks,
Prankur

[Manjuts90]

@Subram try below statement and check.

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

[Subram (SubramRPA)]

Thanks - I got the below error

[dkollyns (Diógenes Kollyns)]

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

[sanjay21051990 (sanjay shankhla)]

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