topic Re: More Script Help in Operating System - HP-UX

More Script Help

Greg Stark_1 — Mon, 29 Apr 2002 14:39:05 GMT

I'm trying to write a script that will purge a faxing database and I'm hung up on the way the shell interprets the following line:

faxstats -OUTBOUND -admin -all |sed '/$UPTO/,\$d'

where $UPTO is a date variable, i.e. "Apr 15"

If I surround the command in echo "" it prints the correct command and information. But, when I run it from a script I get the following error:

sed: 0602-404 Function /$UPTO/,\$d cannot be parsed.

Any ideas?

Thanks again,
Greg

Re: More Script Help

A. Clay Stephenson — Mon, 29 Apr 2002 14:49:34 GMT

Hi Greg:

I'm not sure that I quite understand what you want to do but if all you want to do is delete all lines that have 'Apr 15' in them then this should do it:

UPTO="Apr 15"
faxstats -OUTBOUND -admin -all |sed "/${UPTO}/d"

Note the use of the double quotes to allow the varuable to be evaluated.

Re: More Script Help

Sachin Patel — Mon, 29 Apr 2002 15:07:29 GMT

Hi Greg,
I thing you are trying to replace $UPTO by ",$d"

example
# t="somethis apr 15"
# t1="apr 15"

replace apr 15 by ttt

# echo $t |sed "s/$t1/ttt/g"

Sachin

Re: More Script Help

Greg Stark_1 — Mon, 29 Apr 2002 15:07:43 GMT

Perhaps I should give some more info. The fax software can delete entries in the database up to a certain date. I want to run this script each day and delete all entries older than 14 days (this is what you helped me with on Friday - caljd.sh).

Before actually deleting the fax entries, I want to log which entries will be deleted. To do this I am using the "faxstats -OUTBOUND -admin -all" command to do a listing of the current entries in the database and sed to parse out the entries that are before the given $UPTO date. The faxstats/sed command works from the command line. It also seems to be loading the correct date variable when I echo the command in the script.

I have attached the script so far as well as a portion of the output of faxstats -OUTBOUND -admin -all.

Thanks again,
Greg

Re: More Script Help

A. Clay Stephenson — Mon, 29 Apr 2002 15:21:25 GMT

Okay Greg, you could use grep to do this but you are wise to use sed to both print the pattern AND to do the deletion - that way you know that both operations zig or zag in unison.

To print the lines to be deleted:

UPTO="Apr 15"
faxstats -OUTBOUND -admin -all |sed -n "/${UPTO}/p"

Note the use of the -n option to suppress the default output.

Re: More Script Help

Sachin Patel — Mon, 29 Apr 2002 15:22:32 GMT

Hi Greg,
If I understand correctly then you want to delete fax data older then 14 days and before you delete you want to save that to log file.

faxstats -OUTBOUND -admin -all | grep ${UPTO} > fax.logfile

then
as Clay says delete it
faxstats -OUTBOUND -admin -all |sed "/${UPTO}/d"

Sachin

Re: More Script Help

Mark Fenton — Mon, 29 Apr 2002 16:51:21 GMT

Greg,

shouldn't that work if you fed sed double quotes instead of single? Single quotes force passing literal contents, whereas double quotes allow shell to expand expressions, which is what you want, no?

Clay -- school me if I've got this wrong...

Re: More Script Help

Peter Kloetgen — Mon, 29 Apr 2002 17:00:30 GMT

Hi Greg,

this is a quoting problem:

\ quotes one meta character, which follows directly

'quoted_string' quotes EVERY meta character inside, the only thing not quoted is " ' " itself! No variable subsittution or command substitution inside of quoting! ( This is your problem.... )

"quoted_string" -->>> some meta characters are quoted, but within quoting variable substitution and command substitution is done!

So this should do it for you! Simply use "" instead of '' for quoting.

Allways stay on the bright side of life!

Peter

Re: More Script Help

Greg Stark_1 — Mon, 29 Apr 2002 17:52:18 GMT

Thanks Mark and Peter! That did it. Clay, I'm sure if I would have explained it better, you would have known what I was getting at.

Thanks again,
Greg