Shell Programming and Scripting

I have a static csv file containing two columns (reporttype as 1st column and reportname as 2nd) as follows:
Transaction,TRN_alltransactions
Transaction,TRN_alltransactions1
Master,MST_allmasters
Master,MST_allmasters1
.
.
.
and so on

I am running a script to ftp all the report files from a remote server to a folder on my local linux machine. The report files are named in the following format
RemoteMachineName_reportNameYYYYMMDD.csv / RemoteMachineName_reportNameYYYYMMDD.csv.zip
e.g. PRDSRV1_TRN_alltransactions20081215.csv / PRDSRV1_MST_allmasters20081215.csv.zip

Now on a daily basis I want to create a directory by the date i.e. yyyymmdd and a subfolder of reporttype under that and move respective report files in appropriate folders

Requirement:
Create folders as:
20081215/Transaction
20081215/Master

Move files PRDSRV1_TRN_alltransactions20081215.csv to folder 20081215/Transaction

Move files PRDSRV1_MST_allmasters20081215.csv.zip to folder 20081215/Master

and so on

How do i achieve this using the static csv and the report files that i download?

Use the date program to generate yourself a custom-formatted date:

Code:

filedate=`date +%Y%m%d`
echo $newname
mkdir -p $filedate/Transaction $filedate/Master

Now with BASH or KSH or ZSH use the {%} splicing function to chop off your filenames' extensions, insert the date variable, and then reapply the extensions:

Code:

mv $TransactionReport $filedate/Transaction/${TransactionReport%.csv}${filedate}.csv
mv $AllMastersReport $filedate/Master/${AllMastersReport%.csv.zip}${filedate}.csv.zip