Shell Programming and Scripting

I am trying to write a script that will parse out the e-mail address of a person from the name of a file in a directory.

Example:

filename is:

/home/myname/first.middle.last@email.com.xls

I want to extract just the email address and mail the file to that address.

I want to send the first.middle.last@email.com.xls file to
first.middle.last@email.com

I tried to use awk for this, but I can't seem to get the syntax right.

#!/bin/sh
curdir="/home/myname"

files="$curdir/*.xls"

echo " SPREADSHEETS TO BE SENT " >> /home/myname/xls.logfile

for filename in $files

do
echo $filename >> /home/myname/xls.logfile
awk ' { print substr( $0, 24, length($0) -4) >> $s } ' $filename
echo $s >> /home/myname/xls.logfile
done

I appreciate all help.

Try this (run it inside the xls directory):

Code:

for f in *.xls; do
  uuencode "$f" "$f"|mailx -s "Sending you $f" "${f%.xls}"
done

If it's not binary (MS Excel) data:

Code:

for f in *.xls; do
  mailx -s "Sending you $f" "${f%.xls}"<"$f"
done

Edit: And if for whatever reason you want to loop from another dir:

Code:

for f in /dir/with/files/*.xls; do
  f="${f##*/}"
  echo "uuencode "$f" "$f"|mailx -s "Sending you $f" "${f%.xls}""
done

try this

Code:

 
filename=`basename /home/myname/first.middle.last@email.com.xls`
emailadd=`basename /home/myname/first.middle.last@email.com.xls .xls`

That worked! Can you give me a quick explanation of what it is doing? Sorry, I'm pretty new to scripting.

You don't need awk; use shell parameter expansion.

Don't do that! It will break your script if any filenames contain whitespace. Always use filename expansion directly:

Code:

for filename in "$curdir"/*.xls
do
  base=${filename##*/}
  email=${base%.xls}
done

I suppose you're asking about the parameter expansion:


This is usually described in your shell man pages under Parameter Expansion.

i think its similar to what i suggested..