'sed' search query!!!

sumitdevbharadwaj · 07-10-2009, 12:05 AM

Hi All,

I have a tabular file, say:

$ cat testfile
ABC 123 Delhi
DEF 123 Agra
GHI 456 Bangalore
JKL 123 Mumbai

when I run run the command : sed -n '/123/p' testfile
it gives me correct o/p:
ABC 123 Delhi
DEF 123 Agra
JKL 123 Mumbai

NOW, what should be the command to get the third i.e. unmatched line only :
GHI 456 Bangalore

Thanks in advance.

Sumit Dev Bharadwaj

syg00 · 07-10-2009, 12:23 AM

Better done with grep - it has a switch for this. Check the manpage.

Uncle_Theodore · 07-10-2009, 12:25 AM

Like this?

Code:

 sed -n '/123/!p' testfile

sumitdevbharadwaj · 07-16-2009, 01:50 PM

Hey Thanks Uncle Theodore....I tried and it worked....cheers!!!

pixellany · 07-16-2009, 02:17 PM

Are you sure that's what you want? (It will print EVERY LINE that does not contain the string "123")

What about the following:

Quote:

ABC 5123 New York
DEF 1235 Paris

sumitdevbharadwaj · 07-17-2009, 02:24 AM

Yes Pixellany, thats what I wanted, all the lines except the ones containing 123.

In the example quoted by you above, yes I would like to have these lines:
ABC 5123 New York
DEF 1235 Paris
also for my output.

Thanks for your concern anyways... :-)

pixellany · 07-17-2009, 02:32 AM

Quote:

Originally Posted by sumitdevbharadwaj

Yes Pixellany, thats what I wanted, all the lines except the ones containing 123.

In the example quoted by you above, yes I would like to have these lines:
ABC 5123 New York
DEF 1235 Paris
also for my output.

Well, then Uncle Theodore's code will not work!! The lines above will NOT be printed, because they contain "123".

colucix · 07-17-2009, 03:34 AM

Try grep as suggested above. Options -vw should do the trick.

sumitdevbharadwaj · 07-19-2009, 01:31 PM

Oops...my mistake...I didn't look at the example carefully.
Pixellany you are right.

In the example above by Uncle Theodore, I would not like to have those lines quoted above. Moreover in my actual scenario, the column containing numbers has a definite number of digits, so this thing should not be an issue for me. Anyway, Uncle's command is working very fine for me!!!
Thanks colucix...once I try ur trick, I'll inform what was the result.
Cheers!!!