UNIX for Dummies Questions & Answers

I have a requirement which will select the files with a specific naming convention which got created in past 7 days in a specific directory.Lets say the directory is /data/XYZ and the file names follow the below nomenclature like Daily_File*.txt
I just need to create one CSV file which will contain the file name,record count of the file and its size(bytes or KB or MB or GB mentioned along with the value).

Can anyone please help me writing this script.

If by "record count" you mean "line count", read the wc command's manual page.

Code:

wc /data/XYZ/Daily_File*.txt | nawk -v OFS=, '{ print $4, $1, $3 }'

I guess the "below nomenclature" was supposed to explain something more about what would come after Daily_File but you didn't explain that. The above will run over all the files.

Its line count .
So
wc -l /data/XYZ/Daily_File*.txt | nawk -v OFS=, '{ print $4, $3, $1 }'

How it will find the filesize.Usually the file size is presented by K or G or M in unix and only the numeric value in case of bytes.I want to have KB MB GB Bytes in my CSV file.
Like

Daily_File_Students.txt,1500,10 MB
Daily_File_Teachers.txt,1100,11 MB
Daily_File_Staff.txt,50,10 KB
Daily_File_Fees.txt,112,220 Bytes

Take out the -l from the wc command and you get byte (and word) counts for each file as well. (Why did you add it in the first place?) Some simple post-processing to divide by 1,000 or 1,024 and increasing the unit is easy to add to the awk script. (Do you want MB or MiB, i.e. 1000 or 1024? See http://en.wikipedia.org/wiki/Mebibyte)

Code:

wc /data/XYZ/Daily_File*.txt |
nawk -v OFS=, '{ bytes=$3; suff="KMGT"; i=0;
   while (bytes > 1000) { bytes = int(bytes/1000); i++ }
   print $4, $1, bytes (i > 0 ? (" " substr(suff,i,1) "B") : " bytes") }'

For 1024-byte units, bytes >>= 10 is probably more efficient than bytes = int(bytes/1024)

As an engineering recommendation, I would still suggest that you put the raw numbers in the CSV file, and leave the arrangement of the presentation as KiB or whatever to the consumer of that file.

Thanks for the code..
But the initial requirement was to have the files created in past 7 days.We need to chek the date of file creation before posting them in the CSV file.
Can you please let me know how this code can be modified to incorporate the above requirement.

Code:

find /data/XYZ -mtime -7 -name 'DailyFile*.txt' -print | xargs wc ...

The command you gave gives the word count of the file.I want the total number of files (line count).