topic Re: Script/awk/sed question in Operating System - HP-UX

Script/awk/sed question

Duke Nguyen — Wed, 07 Aug 2002 11:50:41 GMT

I am trying to search a text file for a particular string and print that string plus the next n number of characters following that string. For example:

Contents of text file:
1234 qwer Phone 123-123-1234
76 wejyf Phone 567-325-8765
Phone 983-876-3241 3 deddfgh
q Phone 000-335-6593 ddi555

Want output to be:
Phone 123-123-1234
Phone 567-325-8765
Phone 983-876-3241
Phone 000-335-6593

What would be the best way to accomplish this? Thanks in advance.

Duke

Re: Script/awk/sed question

Tom Maloy — Wed, 07 Aug 2002 11:59:03 GMT

Assume Phone is your pattern.
Assume the data is in file yourData.
Assume you need 18 columns (characters) at the end (Phone xxx-xxx-xxxx).

grep Phone yourData | sed -e "s/.*Phone/Phone/" | cut -c1-18

grep finds the pattern.
sed deletes characters in front of the pattern.
cut keeps the number of characters you want.

Tom

Re: Script/awk/sed question

H.Merijn Brand (procura — Wed, 07 Aug 2002 12:06:07 GMT

perl -pe 's/^.*\b(Phone\s*[-\d]+)\b.*$/$1/' phone-file

Re: Script/awk/sed question

Hai Nguyen_1 — Wed, 07 Aug 2002 12:13:31 GMT

Duke,

This should work as well.

# sed 's/^.*Phone/Phone/' text_file | awk '{print $1 " " $2}'

Hai

Re: Script/awk/sed question

Robin Wakefield — Wed, 07 Aug 2002 13:02:12 GMT

...or even:

sed 's/.*$Phone [^ ]*$.*/\1/' filename

Rgds, Robin

Re: Script/awk/sed question

Duke Nguyen — Wed, 07 Aug 2002 14:03:58 GMT

Thanks everyone!