QUOTE (aussie_dba @ Jul 14 2008, 04:31 PM)
"could you please provide me a logic for that."
OK, you want to sort the csv file names, placing the oldest one first.
ls *.csv|sort > sorted_list.txt
Actually we donot know the name of the file initially,and we have to process file (with file name.this file have dynamic name not static EX: yestarday it generate 845409-07112008.csv & Next day it generate 845429-07112008.csv file So in this case we donot predict file name),My question Question is how we can process these files,Another possibility is that if Back date file and Cureent date file is available at ftp then we have to process back date file first but in this case we also do not know the file name that generate dynamically.