cancel
Showing results for 
Search instead for 
Did you mean: 

filter negative% number within a column of collections Text.

AlejandroPulga1
Level 2
  Hello, I have the following question. I'm trying to filter number
3 REPLIES 3

AlexeyVasiliev
Level 2
If you need to filter only negative numbers, you can use ""InStr"" function, for example: ""InStr([Collection.Field1];""-"") > 0"", and then copy found value to another collection. InStr function works like Regex in OOP languages (looking for matches in strings which need to find). If I understood you correctly.

John__Carter
Staff
Staff
You could try making the query convert the text value to a numerical value so that you can use the

Hitesh__Mhatre
Level 4
Hi, Go through this link will help to create filter expressions https://msdn.microsoft.com/en-us/library/system.data.datacolumn.express…