I have a directory where I am writing lots of files but I know each of them fall under one of the 3 pre-determined memory sizes based on what I write. Any file I write may be either 300KB or 129.1MB or 251MB. Now if there is any packet error in the incoming data, the files that I write will not fall under one of these buckets. Since there will be so many files generated I will not be able to check the individual file size manually. Hence I need a way by which I can group all files by its size so that most of the files will fall under the three category mentioned above and I can easily find the files that are bad.
In short I want something like this: select file_names from folder and group by file_size. Is it possible?
Edit: It would be even better if anyone can give me a solution by which I can: select file_names from folder whose filesize not in [300KB,129.1MB,251MB]. Any ideas?