topic Re: Search pattern from a file in Operating System - HP-UX

Search pattern from a file

Rahul_13 — Fri, 24 Sep 2004 18:18:02 GMT

Hi,

I have to search a particular pattern in a file and extract only the pattern and the word that follows the pattern separated with colon. For example if the file contains a line

....................abc : def...............

I want to pick only "abc : def" from the line.

Can anyone please help me out in this issue.

Thanks,
Rahul

Re: Search pattern from a file

Sundar_7 — Fri, 24 Sep 2004 18:25:52 GMT

Try this

grep " abc :" inputfile | sed 's/.*$ abc :$$ .* $.*/\1\2/'

Re: Search pattern from a file

Hein van den Heuvel — Fri, 24 Sep 2004 21:30:35 GMT

Or with perl:

perl -ne 'print "$1\n" if (/(abc :\s+\w+)/)' inputfile

-ne = loop over input file and program to follow'
$1 = matching text remembered between parentheses.
abc : = primary mathc string
\s+\w+ = secondary match = some white space followed by one or more 'word' characters (a-z,A-Z,0-9,_)

You may need to define more clearly what a word means to you if this does not work.

Hein.

Re: Search pattern from a file

Muthukumar_5 — Sat, 25 Sep 2004 01:07:28 GMT

We can do this with sed / perl there. awk will need more programming there.

Simply with sed as,
$ cat file.1
test for now abc : def okie
bye for now
test abc : def over
$ sed -e '/abc : def/!d;s/.*$abc : def$.*/\1/' file.1
abc : def
abc : def

It will check /abc : def/ there and delete others and try to print only that pattern in the selected line.

Re: Search pattern from a file

Bharat Katkar — Sat, 25 Sep 2004 03:05:56 GMT

Rahul,
if there is only one colon per line then this should also work.
# export patt="abc:"
# cat filename | grep $patt | cut -d ":" -f2

This will display all the words followed by pattern:

Hope that helps.
Regards,

Re: Search pattern from a file

Muthukumar_5 — Sat, 25 Sep 2004 05:21:43 GMT

We can do with awk program as,

Is your pattern abc: then,
awk '{ for ( i=1; i<=NF; i++ ) if ( $i == "abc" && $(i+1) == ":" ) print $i" "$(i+1)" "$(i+2) }'

If abc: .. then,
awk '{ for ( i=1; i<=NF; i++ ) if ( $i == "abc:" ) print $i" "$(i+1) }'

Re: Search pattern from a file

Anand_30 — Thu, 21 Oct 2004 17:28:27 GMT

Hi MuthuKumar,

I tried using your awk solution for the line in the attached file to get the pattern 'Status:40' but it did not return any values.

Can you please look into it.

Thanks,
Rahul

Re: Search pattern from a file

Hein van den Heuvel — Thu, 21 Oct 2004 20:54:20 GMT

Rahul,

[In the future you may want to startup you own topic, referecing back to the original topic]

The solution Muthukumar proposes hinges on a space seperating the search target from the value target. Your file does nto have a space. We can tweak the solution to allow for both spaces and colons to be a seperator:

awk -F "[ :]" '{ for ( i=1; i<=NF; i++ ) if ( $i == "Status" ) print $i" "$(i+1) }' inputfile

Personally I find think my perl solution, just using a regular expression is more elegant:

perl -ne 'print "$1\n" if (/(Status:\w+)/)' inputfile

If neither of these suggestion solve your problem, then you need to open your own topic and explain exactly (in words) what the search pattern looks. For example: "the word "Status", followed immediatly with a colon and a numeric value".

Cheers,
Hein.

Re: Search pattern from a file

Muthukumar_5 — Fri, 22 Oct 2004 01:17:59 GMT

Rahul,

We can use hein's method of perl or simply as,

$ awk '{ for (i=1;i<=NF;i++) if ($i=="Status:40") print $i }' anandh
Status:40

Your input file need not be separated with Field separator : there.

If you want to do with file separator : then,

$ awk -F "[ :]" '{ for ( i=1; i<=NF; i++ ) if ( $i == "Status" && $(i+1) == 40 ) print $i":"$(i+1) }'

Status:40

You can this users question and answers to know about awk programming as,
http://forums1.itrc.hp.com/service/forums/publicProfile.do?userId=CA1196931&forumId=1

HTH.

Re: Search pattern from a file

Rahul_13 — Fri, 22 Oct 2004 17:21:34 GMT

Hi,

Both the solution works, but I have a new requirement. I have a file with multiple lines and I need to search for the pattern in the file. Display the pattern for whichever lines the pattern is found and display a blank for the lines where the pattern a not located. For example:

If the input is

..............Status:30.................
..............Status:40...................
..........................................
............................................
..............Status:80.....................

The output should be:

Status:30
Status:40
blank
blank
Status:80

Can you please help me.

Thanks,
Rahul

Re: Search pattern from a file

Hein van den Heuvel — Fri, 22 Oct 2004 21:54:05 GMT

Easy... You can figure this out with a little bit of perl/regexpr/grep/sed/awk learning.

perl -pe '$_=(/(Status:\w+)/)?"$1\n":"\n"' input_file

This tells perl to
-pe = Loop through the file and print $_ for each line.
(/../) = Look for "Status:" followed by a word (no spaces).
$_ = ()?..:.. = If matched assign match to $_ otherwise assign empty string.

btw...

I wrote "In the future you may want to startup you own topic, referecing back to the original topic" because you used a different author name (Anand).

Cheers,
Hein.