Shell Programming and Scripting

Hi,
I need to extract last character of the field retrieved from the database using select command.
eg:
select event,text from event_data;
o/p: Event1,text1

But I need to extract only '1' from the fields...similarly '2' from Event2,text2 and '3' from Event3,text3 etc., and need to pass these extracted digits to a command.
it will be like :

EventRun -r '1' ( '1' from Event1 of select query) -p 1 ('1' from text1 of select query)
i.e.,
EventRun -r 1 -p 1

Can anyone please help me out in this

With expr,

Code:

$ var=Event1,text1
$ expr $var : '.*\([a-zA-Z0-9]\)'
1
$

I should pass the extracted digit from the fields as input to a command..Event1 and Text1 here are two fields extracted from database.
But I need to pass only the numeric value ( 1 for event1 and 1 for text1) at the end of each filed as input to the command.

EventRun -r 1 -p 1

try,

Code:

v=${var##${var%%?}}
EventRun -r $v -p $v

The part I need to write should be like..
EventRun -r -i 'select $ awk '{print "select event,text from event_data}'

similar to the above I should be able to pass last digits of the extracted data to the above query.
-r and -i are to be passed dynamically from the query output.

I didn't understand.
The solution can be fit to your requirement. you can off course adjust/re-use it to match with.

If you are sure the last character would always be a digit and want to pass sequentially,

Code:

$ a=T3,B2
$ echo $a | sed 's/.*\([0-9]\),.*\([0-9]\)/\1 \2/'
3 2
$

You can later use it this way

Code:

$ set -- $(echo $a | sed 's/.*\([0-9]\),.*\([0-9]\)/\1 \2/')
$ EventRun -r $1 -p $2

# would actually result
$ EventRun -r 3 -p 2

Thanks for the Solution :-)
I hope it works..will check it now ..ty again