How to search for numbers greater than less than?

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
smhsha
Posts: 1
Joined: Wed Jul 16, 2003 5:13 am

How to search for numbers greater than less than?

Post by smhsha »

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.
jreyes1000
Posts: 4
Joined: Thu Mar 27, 2003 1:09 pm

Post by jreyes1000 »

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...)
User avatar
MudGuard
Posts: 1295
Joined: Sun Mar 02, 2003 10:15 pm
Location: Munich, Germany
Contact:

Post by MudGuard »

To find four digits:

[0-9]{4}

or

[0-9]\{4\}

depending on Posix Regex setting
Post Reply