Finding files with names that have a real number greater then difined.

harmonwood · #1 (**permalink**) 11-09-2007

I am trying to find all files in a directory whose name has a real number larger then the number I am looking for.

For example:

.
|-- delta.1.5.sql
|-- delta.2.1.sql
|-- delta.2.2.sql
|-- delta.2.3.sql
|-- delta.2.4.sql
`-- delta.2.5.sql

I know my database is at 2.2 so I want an output like this:

delta.2.3.sql delta.2.4.sql delta.2.5.sql

I am using bash. Could somebody help me with this?

radoulov · #2 (**permalink**) 11-09-2007

Code:

awk '$2FS$3>v' v="2.2" FS="." <(printf "%s\n" delta*.sql)

harmonwood · #3 (**permalink**) 11-09-2007

Awesome, that's exactly what I needed : )

Thank you

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Show result only if number is greater then	umen	Shell Programming and Scripting	1	12-05-2007 04:03 AM
total number of files which have "aaa" in files whose names are File_bbb	sudheshnaiyer	UNIX for Dummies Questions & Answers	1	08-16-2007 02:34 PM
how to find capital letter names in a file without finding words at start of sentence	kev269	Shell Programming and Scripting	1	04-10-2006 09:35 PM
[awk]: Row begins by random number and field 10 is greater than 10.00%	Lomic	Shell Programming and Scripting	3	03-18-2005 09:59 AM
finding the number of open files	jyotipg	UNIX for Advanced & Expert Users	1	05-20-2002 09:18 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by