hi,I am new to shell script,I have String,like this:
Number of rows exported: 5321
the numbe at end could changing,how can I extract this number and assign it to a variable,then use it later in script.
thanks.

try this.......

hi,That works great,here is another issue.
The String been extract is comes from another shell command,like 'db2 "export blala"',
how can i combine your solution with first shell command.
thanks.

can you post the exact output of your
command....

first command is
db2 "export to ACTIONS.dat of del select * from ACTIONS"
it will created following message:
SQL3104N The Export utility is beginning to export data to file
"ACTIONS.dat".

SQL3105N The Export utility has finished exporting "238" rows.


Number of rows exported: 238

I use grep get last line,and use you code get '238',I want assign this number to a variable like $Number,then i use another command like
db2 "insert into log (tablename,number) values('ACTIONS',$Number)
to insert this number to a db2 table log

problem is how can i combine first db2 command with the extract commands(grep and awk) to assign this number to that variable $Number

this will do the trick...

hi,thanks for reply,still can not make it work,here is several tests i make,hope it give you some idea of problems.
>x=123
>echo $x
123
>x=`db2 "export to ACTIONS.dat of del select * from ACTIONS" |grep "Number of rows exported" | awk -F: '{print $2}'`
>echo $x

>db2 "export to ACTIONS.dat of del select * from ACTIONS" |grep "Number of rows exported" | awk -F: '{print $2}'
238

It is sames that combination clear the variable x,last one print "238",as I am a newbie,I don't know how to make it work.by the way,I am using bash,'>' is command prompt here.thanks