Shell Programming and Scripting

Hello,

I have a bash shell script and I use awk to print certain columns of one file and direct the output to another file. If I do a less or cat on the file it looks correct, but if I email the file and open it with Outlook the lines outputted by awk are concatenated.

Here is my awk line:
awk '{print $6" "$7" "$8" "$9" "$5}' /data/tmp/snapshots_report.deltas >> $EMAIL_BODY

I use a perl script to email it.

Here is how it looks with cat:
[root@rmhesx01 tmp]# cat snapshots_report.email
Adam1:
Jan 12 11:19 Adam1-000001-delta.vmdk 7.0K
Jan 12 11:19 Adam1-000002-delta.vmdk 7.0K
Jan 12 11:19 Adam1-000003-delta.vmdk 16M
Jan 12 11:19 Adam1_1-000001-delta.vmdk 10K
Jan 12 11:19 Adam1_1-000002-delta.vmdk 10K
Jan 12 11:19 Adam1_1-000003-delta.vmdk 10K

Centramax:
Jan 12 11:19 Centramax-000001-delta.vmdk 16M

Looks like this in my email client:

Adam1:
Jan 12 11:19 Adam1-000001-delta.vmdk 7.0K Jan 12 11:19 Adam1-000002-delta.vmdk 7.0K Jan 12 11:19 Adam1-000003-delta.vmdk 16M Jan 12 11:19 Adam1_1-000001-delta.vmdk 10K Jan 12 11:19 Adam1_1-000002-delta.vmdk 10K Jan 12 11:19 Adam1_1-000003-delta.vmdk 10K

Centramax:
Jan 12 11:19 Centramax-000001-delta.vmdk 16M

I know that linux uses LF for newline and windows uses CRLF, but I cant figure out if that is what is causing this issue. I have tried adding "\n" to my awk statement but then I get double-spacing which I dont want.

Any ideas?

You can add a CR with your awk command like this:

Code:

awk '{print $6" "$7" "$8" "$9" "$5 "\015"}'

Regards

You might want to investigate dos2unix and unix2dos. These two commands help convert files to adjust for the differences in file structures.
I know that I use these frequently to handle CR (carriage return) and LF (line feed) issues.

Just tried that and the output looks exactly the same.

I have also tried unix2dos with no success.

Here is my full script:
#!/bin/bash
#
# Written by Adam Stahl on 1/9/09
#
# This script emails a report of VMs having snapshots.

PATH=$PATH:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
SCRIPT_NAME=$0
HOSTNAME=`hostname | awk -F. '{print $1}' | tr '[a-z]' '[A-Z]'`
EMAIL_BODY=/data/tmp/snapshots_report.email
FLAG=0

> $EMAIL_BODY

# Loop through all VMs running on the host
for VM_CONFIG in `vmware-cmd -l`
do
# Get the VMs name
VM_NAME=`basename $VM_CONFIG | awk -F. '{print $1}'`
# Get the VMs directory
VM_DIR=`dirname $VM_CONFIG`

# Go into the directory and look for snapshot files
cd $VM_DIR
ls -lah *delta* > /dev/null 2>&1
if [ $? -eq 0 ]; then
ls -lah *delta* > /data/tmp/snapshots_report.deltas
echo $VM_NAME: >> $EMAIL_BODY
awk '{print $6" "$7" "$8" "$9" "$5"\n"}' /data/tmp/snapshots_report.deltas >> $EMAIL_BODY
# echo >> $EMAIL_BODY
FLAG=1
fi
done

if [ $FLAG -eq 0 ]; then
echo "No snapshots exist" > $EMAIL_BODY
fi

# Send the email
/data/scripts/sendmail.pl claven.rhsnet.org $HOSTNAME@rhsnet.org astahl@rhsnet.org "$HOSTNAME: Weekly Snapshot Report" $EMAIL_BODY

best --

Code:

>cat $EMAIL_BODY | od -An -t dC -w10

which will show the file as created. Very interested to see if there are '10' characters and/or '13' characters, which are line-feed and carriage-return.

Could that perl script that is emailing also be involved in this oddity? Have you tried mailx or mutt for email?

Well here is the output of the command you gave me:

[root@rmhesx01 scripts]# cat adam2 | od -An -t dC -w10
86 77 95 78 65 77 69 58 10 32
32 32 32 32 32 10 74 97 110 32
49 51 32 49 48 58 53 52 32 32
46 32 32 52 46 48 75 10 74 97
110 32 57 32 49 49 58 50 48 32
32 46 46 32 32 52 46 48 75 10
65 112 114 32 50 57 32 50 48 48
56 32 32 97 99 116 105 118 101 95
110 105 99 95 99 104 101 99 107 46
115 104 32 32 49 46 49 75 10 74
97 110 32 49 51 32 49 48 58 53
52 32 32 97 100 97 109 49 32 32
48 10 65 112 114 32 50 56 32 50
48 48 56 32 32 115 101 110 100 109
97 105 108 46 112 108 32 32 54 52
54 10 74 97 110 32 49 50 32 48
56 58 52 55 32 32 115 110 97 112
115 104 111 116 115 95 114 101 112 111
114 116 46 115 104 32 32 49 46 48
75 10 74 97 110 32 57 32 49 54
58 51 57 32 32 115 110 97 112 115
104 111 116 115 95 114 101 112 111 114
116 46 115 104 46 98 97 107 32 32
49 46 49 75 10

I am not sure how to interpret that.

I got it working. Using "printf" instead of "print" did the trick.