Solaris

I have an input file which looks like

"
@$SCRIPT/atp_asrmt_adj.sql
$SCRIPT/dba2000.scr -s / @$SCRIPT/cim1005w.pls
$SCRIPT/dba2000.scr -s / @$SCRIPT/cim1006w.pls
start $SCRIPT/cim1020d.sql;^M
spool $DATA/cim1021m.sql
@$DATA/cim1021m.sql
! rm $DATA/cim1021m.sql
spool $DATA/cim1021m.sql
@$DATA/cim1021m.sql
! rm $DATA/cim1021m.sql
start $SCRIPT/art_matrix_audit_purge.pls
start $SCRIPT/event_sku_price_log_purge.pls
start $SCRIPT/event_sku_price_audit_purge.pls
start $SCRIPT/event_sku_rscn_audit_purge.pls
@$SCRIPT/in_process_audit_purge.sql
$SCRIPT/dba2000.scr /NOLOG @$SCRIPT/mphdsum.pls
ERROR_SCRIPT "Error with deduct.pls"
$SCRIPT/dba2000.scr /NOLOG @$SCRIPT/pastdue.pls
ERROR_SCRIPT "Error with pastdue.pls"
$SCRIPT/dba2000.scr /NOLOG @$SCRIPT/ordpos1.pls
ERROR_SCRIPT "Error with ordpos1.pls"
$SCRIPT/dba2000.scr /NOLOG @$SCRIPT/ordpos2.pls
ERROR_SCRIPT "Error with ordpos2.pls"
ERROR_SCRIPT "Error Code:'$RCSUM!' in sum1so.sql"
ERROR_SCRIPT "Error Code:'$RCSUM2' in sum2so.sql"
ERROR_SCRIPT "Error Code:'$RCSUM3' in sum3so.sql"
"

My requirement is to extract all the text b/w :
1). "/" and ".sql"
2)."/" and ".pls"
3)." " and ".sql"
4)." " and ".pls"

It is really urgent, any suggestion would be highly appreciated.
Thanks

Am not sure of your requirement.

Something like this,

Code:

echo "@$SCRIPT/in_process_audit_purge.sql" | sed 's/\.sql//;s/^.*\///'

Also, titles like "Urgent !!! ", I don't think these are encouraged in the forum

Thanks a lot , it serves my requirement. I didn't get what was wrong with the title

Is it descriptive, does it give a browser an idea on what the thread would be about before they click on it?

I usually ignore titles of "Urgent" or "Help".