Filter data from text file - Page 2 - Windows & DOS: Issues & Discussions

era · #8 (**permalink**) 04-14-2008

Code:

awk '/^----*Table/{table=$0}
/^IP=/{ print table }' file

Do you really have a variable number of dashes before the "Table"?

radoulov · #9 (**permalink**) 04-14-2008

Code:

awk '$0 ~ v { printf "%s\n%s\n", x, $0 }
/^--/ { x = "" } { x = x ? x RS $0 : $0 }
' v="^IP=172.18.0.1$" file

Use nawk or /usr/xpg4/bin/awk on Solaris.

Perhaps I misread the question, if you need only the table names,
you should use the code era posted.

Hone1975 · #10 (**permalink**) 04-15-2008

Thank you radoulov and era.

Radoulov solution very near that what I am looking for.

This script (radoulov) print out from tables only those rows which are before IP=x.x.x.x
After IP=x.x.x.x are couple rows more and I like to print out those too.

radoulov · #11 (**permalink**) 04-15-2008

Code:

awk 'END { if (f) print x } $0 ~ v && f++
/^--/ { if (f) print x; x = f = 0 }
{ x = x ? x RS $0 : $0 }' v="^IP=172.18.0.1$" file

Hone1975 · #12 (**permalink**) 04-15-2008

/usr/xpg4/bin/awk: syntax error Context is:
>>> END { if (f) print x } $0 ~ v && f++/---- <<<

radoulov · #13 (**permalink**) 04-15-2008

Quote:

Originally Posted by Hone1975

/usr/xpg4/bin/awk: syntax error Context is:
>>> END { if (f) print x } $0 ~ v && f++/---- <<<

Copy/paste my code,
there's a newline after f++ ...

(why this thread is in Windows & DOS: Issues & Discussions?)

Hone1975 · #14 (**permalink**) 04-15-2008

Quote:

Originally Posted by radoulov

Copy/paste my code,
there's a newline after f++ ...

(why this thread is in Windows & DOS: Issues & Discussions?)

Why this thread: This case was very near of my needs and I am very new forum user and I didn't remenber to check is my case in the right place.

Sorry.

What do you mean new line? If I put your code to my Solaris shell window I get error message (If I copy and paste your code).

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Extracting data from text file based on configuration set in config file	suparnbector	Shell Programming and Scripting	3	08-09-2007 11:25 PM
Exporting text file data to csv	l_jayakumar	Shell Programming and Scripting	3	09-18-2005 08:27 PM
filter data	deep.singh	UNIX for Dummies Questions & Answers	3	08-14-2005 08:24 PM
How to extract data from a text file	negixx	Shell Programming and Scripting	1	07-19-2005 06:30 PM
getting data out from a text file	skotapal	Shell Programming and Scripting	7	09-14-2002 08:10 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode