I have a view that includes a PID column from a linux log file that is populated using the %s feature in the pattern parser. That part is fine. The PID values are clean, just the numbers, no whitespace or other characters.
I would like to filter the view to PIDs using the autofilter, e.g. > 1000,  but it doesn't work. Maybe because LVP does not support fields as numeric,  only fields as text for the autofilter.
If I have a file with rows that include PID values 269 and 1322 I get the following results
PID = 269 - I get the rows with PID 269
PID = 1322 - I get the rows with PID 1322
PID > 1000 - I get the rows with both PID 269 and 1322
The first 2 results are as expected, the 3rd result I just want 1322.
Is there anyway to achieve this?
Thanks in advance