how to filter words

maheshp86 · 08-19-2010, 05:34 AM

hi!!!

pls guide me.

consider the following command

[monitor@lms check]$ mysql -u root -pPassword -e "show master status\G"|grep -v "1. row" | grep Position
Position: 3317310
[monitor@lms check]$

it is giving the output "Position: 3317310", from this how can i filter

only 3317310 ?

carltm · 08-19-2010, 05:41 AM

You could use "sed 's/Position: //'". This uses the stream
editor to replace "Position: " with "".

EricTRA · 08-19-2010, 05:45 AM

Hi,

By piping the output to awk:

Code:

mysql -u root -pPassword -e "show master status\G"|grep -v "1. row" | grep Position | awk '{ print $2 }'

Kind regards,

Eric

maheshp86 · 08-19-2010, 05:46 AM

Quote:

Originally Posted by carltm

You could use "sed 's/Position: //'". This uses the stream
editor to replace "Position: " with "".

sorry

i can't , pls specify clearly

maheshp86 · 08-19-2010, 05:48 AM

Quote:

Originally Posted by EricTRA

Hi,

By piping the output to awk:

Code:

mysql -u root -pPassword -e "show master status\G"|grep -v "1. row" | grep Position | awk '{ print $2 }'

Kind regards,

Eric

thanks a lot ,

sem007 · 08-19-2010, 05:48 AM

[EDIT]

Bit late to post same solution suggested by EricTRA

EricTRA you beat me in typing

EricTRA · 08-19-2010, 05:57 AM

Quote:

Originally Posted by maheshp86

thanks a lot ,

Hi,

You're welcome! If you consider your question/problem solved then please mark it as such using the Thread Tools.

@sem007: That's life, sometimes you win and sometimes you loose

Kind regards,

Eric

sem007 · 08-19-2010, 06:10 AM

Quote:

@sem007: That's life, sometimes you win and sometimes you loose

yes EricTRA that's right but i am not here to win anything

This is nice platform to learn new things and share knowledge Thanks to jeremy and all LQ member.

Regards,

EricTRA · 08-19-2010, 06:12 AM

Quote:

Originally Posted by sem007

yes EricTRA that's right but i am not here to win anything

This is nice platform to learn new things and share knowledge Thanks to jeremy and all LQ member.

Regards,

Hi,

I was just kidding! I'm here for the same reason as you are, to learn stuff, share knowledge and help out where I can. Sorry if I somehow offended you with my 'joke'.

Kind regards,

Eric

sem007 · 08-19-2010, 06:18 AM

Quote:

Originally Posted by EricTRA

Hi,

I was just kidding! I'm here for the same reason as you are, to learn stuff, share knowledge and help out where I can. Sorry if I somehow offended you with my 'joke'.

Kind regards,

Eric

nop dear you never hurt me. i mean to say i not here to win but to learn.

it might be language problem because English is not my native language.