Shell Programming and Scripting

Hi All,

I am using a informatica job to create a csv file and a unix script the mail the generated file.Everything is working fine but I am not seeing leading zeros in the csv file sent in the mail.These zeros were present when the .csv file was generated by informatica procees.

Is there any command which I can use in shelll script which will dfisplay that?Please help

Code:

fdate=`tail -1 abc.csv | cut -c1-8`
SUBJECT="execp : ${ENV} for ${fdate}"
destname=file_$fdate
sed 's/#BUSINESS/BUSINESS/1' abc.csv > abc2.csv
mv abc2.csv abc.csv
line_count=`wc -l abc.csv|awk '{print $1}'`
echo $line_count
if [ $line_count -gt 1 ]
then
(echo "Hi,Team";uuencode abc.csv $destname.csv) | /usr/bin/mailx -s  "${SUBJECT}"  ${TO} ${CC}

As there are no steps eating leading zeroes in above script, where are you "not seeing leading zeros"? In $destname.csv? On the destination host? In a spread sheet progeam?

Hi Rudi,

This unix script mails the .csv file which is already created by a informatica process.I am not seeing leading zeros when the script mails the .csv file and when we open the mail attachement.
Those zeros are present when the csv was created

and how do you open the mailed file?

it comes in as an attachement.Double click

Please post (shrunk but meaningful) samples of abc.csv, $destname.csv, and the target file on the remote host.

heh - good answer.
You open it with Excel?
Try opening with the notepad and see