I have a log file that's generated on a daily basis, and saved with the Month and day at the end of it. For instance: file_type_Aug17.csv. As part of my excel conversion I need my script to search for the current Month and day(Aug17) and convert it. Thanks for your help!

you mean you wanna convert your file to .csv format??
date "+%m"=Aug
date "+%d"=17
concate them you get Aug17 then search using find command or grep it then convert it..
give it a try.. if not possible we will help you out..

Thanks for your help!

Here's what I have so far.

rm -rf file_file_perf_Aug18.xls
chmod 777 file_file_perf_Aug19.csv
awk -f csc2xls < file_file_perf_Aug19.csv > file_file_perf_Aug19.xls
chmod 777 file_file_perf_Aug19.xls
I have to manually change the number in the date to complete the task. I indicated in the original post the current Month and day. My mistake, not the current day, I need to this script find the day before. Thanks

try changing TZ
echo "$TZ"
if it shows TZ=IST-5:30
change it to TZ=IST-24
then type date you get next date then extract date in whichever way you want and search using that.. for you file..

echo "$TZ" works for me and the result is US/Eastern

Since I'm new to this, in my script what should be my layout.
Here's what I'm trying to accomplish.

I'm trying to automate this as much as possible. These reports are generated the day before. Now in the morning 12AM the next day I need to email an excel formatted report to the heads.

the system generates a csv file that is -rw-r--r--, I normally have to chmod to perform execute.

How would I implemented the date portion into my script to pull or parse the correct file with the naming convention I provided?

See if this helps you to get previous date.

- nilesh

Thanks!

This portion of the script is displaying
bash-3.00$ CURRENT_DATE='date + %Y%m%d'
bash-3.00$ echo "$CURRENT_DATE"

this output
date + %Y%m%d