Community

I have the below in my log files I need to find the entries that are only greater than 1000 or so.

e.g.
DBQueryTime="998"
DBQueryTime="1434"

How this can be achieved? Even something like search any entry that has
4 digits will do.

Thanks,
Shakila.

Assuming that all your records are prefixed with 'DBQueryTime="', you can do a numeric sort starting on position 14.

For example:

- Open your file.
- Navigate Tools --> Sort
- Fill in..
First Key: From: 14
First Key: Length:
Sort Order: Ascending
Comparison: Numeric (<--- very important...)

To find four digits:

[0-9]{4}

or

[0-9]\{4\}

depending on Posix Regex setting