Shell Programming and Scripting

Please don't count this as a similar post.....I got the ftp part working....I am stuck how to find the files between two dates.
I have 5 files
filename.20090505.txt
filename.20090504.txt
filename.20090503.txt
filename.20090502.txt
filename.20090501.txt
My load date is 20090501 and run date is 20090505. I have to retrieve the files in between filename.20090504.txt,filename.20090503.txt,filename.20090502.txt based on the dates on the filename.
Pls help me.
Thanks in advance.

Code:

awk -F"." '$2 < 20090505 && $2 > 20090501'

Thanks franklin.... but when I type ur command i am not getting anything....I am not so good please help also I forgot I need the run_date file too. i.e filename.20090505.txt,filename.20090504.txt,filename.20090503.txt,filename.20090502.txt
awk -F"." '$2 < 20090505 && $2 > 20090501'
Pls can u elaborate
Thanks again

Can you post what you have so far so we can understand where the list of filenames is coming from?

franklin52 example would process the vertical list of filenames in you first post either from a pipe or from a file.
e.g. from a file called my_list_of_files :

Code:

awk -F"." '$2 < 20090505 && $2 > 20090501' my_list_of_files
filename.20090504.txt
filename.20090503.txt
filename.20090502.txt

With ftp only it's probably going to be a three stage process?
1) Get a directory listing of the remote server directory and store it in a file on the local server.
2) Process the stored list to eliminate files which we have fetched already.
3) Fetch the files and record which ones have been processed.

looks like this is perfect but can u plz tell me how to create the "my_list_of_files"

I am sorry to bother....

You can get the file list with ls:

Code:

ls filename*.txt >  my_list_of_files
awk -F"." '$2 < 20090505 && $2 > 20090501' my_list_of_files

or without a file list:

Code:

ls filename*.txt | awk -F"." '$2 < 20090505 && $2 > 20090501'