Get file date and hour

[kHz]

Any advice is welcome on getting file date to work with. This is my dilemma: I have a large number of files 17,000+ that are named with a syntax like this:

AR1229@01.txt.Z

with a file for every state, hence a FL1229@01.txt.Z, etc., and a file for each hour, hence there are 24 files for each state everyday. This has been going on for 3 or 4 weeks. I did not set this up but have been tasked with summarizing the data inside the files.

But the data only needs to be summarized between the 00 and 23 hours. So if there were total files of 11,200 at 00 and 11,300 at 2300, then there is are 100 new files for that day.

Does anyone have any recommendations on being able to get file OH0104@00 and compare the data to the file OH0104@23? As I said there are 17,000+ files, so I am perplexed on how I can separate all the files for each day for each state and only work with them.

Compare:
GA1229@00 with GA1229@23
IL0105@00 with IL0105@23
.
.
.

Any advice would be great. Also, the individual who set this up originally is compressing all the text files, so they are named AL0110@14.txt.Z, etc.

Thanks for any tips, advice, recommendations!!!

 

[stefanwagner]

I would start with something like...

for file in *@00 ; do 
    cmp=$(echo $file | sed 's/@00/@23/g')
    compare $file $cmp
done

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung