awk help needed

Drenhead · #1 (**permalink**) 10-09-2008

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.

radoulov · #2 (**permalink**) 10-09-2008

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

Drenhead · #3 (**permalink**) 10-09-2008

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

Quote:

Originally Posted by radoulov

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

radoulov · #4 (**permalink**) 10-09-2008

Quote:

Originally Posted by Drenhead

That worked! Can you give me a quick explanation of what it is doing? [...]

I suppose you're asking about the parameter expansion:

Quote:

${variable #pattern} value of variable without the smallest beginning portion that matches
pattern
${variable ##pattern} value of variable without the largest beginning portion that matches
pattern
${variable%pattern} value of variable without the smallest ending portion that matches
pattern
${variable%%pattern} value of variable without the largest ending portion that matches
pattern

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

vidyadhar85 · #5 (**permalink**) 10-09-2008

try this

Code:

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

cfajohnson · #6 (**permalink**) 10-09-2008

Quote:

Originally Posted by Drenhead

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.

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

Quote:

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

files="$curdir/*.xls"

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

for filename in $files

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

vidyadhar85 · #7 (**permalink**) 10-09-2008

Quote:

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

i think its similar to what i suggested..

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Help needed please.	jerryboy78	UNIX for Dummies Questions & Answers	3	03-16-2008 02:06 PM
little help needed..	hilofat	UNIX for Dummies Questions & Answers	3	02-03-2008 11:48 AM
Help needed	akhil1460	UNIX for Dummies Questions & Answers	1	06-18-2006 11:16 PM
Help needed	hunter87	UNIX for Dummies Questions & Answers	3	06-02-2006 12:45 AM
Help needed in awk	Vikas Sood	Shell Programming and Scripting	1	05-22-2006 11:11 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by