Hi,

How can I removed the directory in the input file?

The script responsible for storing the report in an input file is this:

[i]while [ $i -lt "${#penfilename[*]}" ]
do

echo "penetration|${penfilename[i]}|${penfilenamedaterange}" >> ${OUT_DIR}/penrpt_emailfile.txt

(( i=i+1 ))

done

For the penfilename:

penfilename[i]=`echo ${OUTFILE}*"(${daterange})".csv`

Example of an input file is this:
penetration|/app/rms/rms/data/preticketing/penrpt/PenetrationReport_(MANN-6)_ByBuyer_(01-NOV-2007_01-NOV-2007).csv /app/rms/rms/data/preticketing/penrpt/PenetrationReport_(MANN-6)_ByVendor_(01-NOV-2007_01-NOV-2007).csv

Please help me!

I tried this script

penfilename[i]=`echo PenetrationReport*"(${daterange})".csv`

But its not working because it gives me an output of:

penetration|PenetrationReport*(01-NOV-2007_01-NOV-2007).csv.

My objective is to remove the output directory. This the result I'm expecting to have:

penetration|PenetrationReport_(MANN-6)_ByBuyer_(01-NOV-2007_01-NOV-2007).csv PenetrationReport_(MANN-6)_ByVendor_(01-NOV-2007_01-NOV-2007).csv

Thanks a lot!

I didn't understand very well your script, but if you want to get rid of a directory name given a full pathname, try the command "basename", eg.:

Will return:

Hi,

Thanks for your time..

But the problem is, this script basename "/app/rms/rms/data/preticketing/penrpt/PenetrationReport_(MANN-6)_ByVendor_(01-NOV-2007_01-NOV-2007).csv"
is not applicable because those where just the results of the generated report. I cannot directly changed that.

Okay..to better understand:

penfilename[i]=`echo ${OUTFILE}*"(${daterange})".csv` --> this script stores the generated reports. And the generated report is the records in the output file.

Since OUTFILE is consists of the output directory and PenetrationReport.(/app/rms/rms/data/preticketing/penrpt/ --> output directory and PenetrationReport)

I need to removed the output directory but retains the looping.

the responsible script for the looping is this:

[i][i]while [ $i -lt "${#penfilename[*]}" ]
do

echo "penetration|${penfilename}|${penfilenamedaterange}" >> ${OUT_DIR}/penrpt_emailfile.txt

(( i=i+1 ))

done

I hope you can really help me.. This is an urgent task I needed to submit. And I don't know much on unix..

Thanks a lot