False is boolean and rest of of the data in column is normal text. they how to filter this false from that column. i tried different ways to filter it but not working

I have a one column in excel which is filled with normal data…in that i need to filter with False values which is in that column. but this false is boolean and rest of of the data in column is normal text. they how to filter this false from that column. i tried different ways to filter it but not working

Dear @ryava_santhoshi,

if i understand your question , you want to filter false values from the normal data
extract the data into a datatable then use
dt.Select("[ColumnName]="+"’"+boolFalsevalue+"’")
replace columname with the header name and boolfalsevalue is your variable

I hope this helps

1 Like