How to find negative numbers contains in excel column

Help
1

how to find negative numbers contains in excel column,Select filter

2

Are you working with dataTable, or directly with excel ?

3

@kalv,

Use Filter Data table activity to filter column.

Please find the below post:
https://activities.uipath.com/docs/filter-data-table

4

with data table, i have tried this , Dt.Select(“[column] LIKE ‘%-%’”) but it will not work when all data is zero

5

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.

1 Like
6

i am working with excel

7

i have already tried this, its not working

8

I have tried this and work for me!

1 Like
9

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