how to find negative numbers contains in excel column,Select filter
Are you working with dataTable, or directly with excel ?
Use Filter Data table activity to filter column.
Please find the below post:
with data table, i have tried this , Dt.Select("[column] LIKE ‘%-%’") but it will not work when all data is zero
Select return a DataRow (array of datarow) is it ok ?
Then dt.Select(“ColumnName < 0”) should work.
Or <= 0 if you want to include 0.
i am working with excel
i have already tried this, its not working
I have tried this and work for me!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.