Awking

anduzzi · #1 (**permalink**) 02-08-2009

Could someone find out wht exactly is goin wrong in the following awk:

awk '/${EDW_DB_SCHEMA}.WRKR/ || !/otable/&&/${EDW_DB_SCHEMA}.WRKR/ || !/db-ter-load-data/&&/${EDW_DB_SCHEMA}.WRKR/' <my_graph>.ksh

Basically, I am trying to achieve:
Find out the occurence of WRKR table in <my_graph>.ksh and at the same time AVOID the following combinations:
1.'otable' and ${EDW_DB_SCHEMA}.WRKR
2.'db-ter-load-data' and ${EDW_DB_SCHEMA}.WRKR

and the WRKR table appears as "${EDW_DB_SCHEMA}"'.WRKR' in the korn shell(.ksh) and also, I am looping thru a list of ksh files under a given dir as I don't know which ksh file uses this table..

hope this is clear !
pls suggest !
-Anduzzi

JerryHone · #2 (**permalink**) 02-08-2009

${EDW_DB_SCHEMA} won't expand within single quotes.

Jerry

vgersh99 · #3 (**permalink**) 02-08-2009

Here's the general idea, but you'll have work out your binary logic as I think the conditions are repetitive....

Code:

awk -v db="${EDW_DB_SCHEMA}" '$0 ~ (db ".WRKR") || !/otable/ && $0 ~ (db ".WRKR") || !/db-ter-load-data/ && $0 ~ (db ".WRKR")' *.ksh

anduzzi · #4 (**permalink**) 02-09-2009

Hi Vgersh,
Thanks for your inputs !.
Could you please explain the $0 in that command?...its not quite working at my end...I understand that you have defined a variable and used it thru out but not quite gettig the syntax...please explain !

-Anduzzi

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
awking and grepping parts of files: the 'super diff'	jeffpas	Shell Programming and Scripting	11	07-17-2008 06:54 PM
Awking!! Printing decimal output is struck	divzz	Shell Programming and Scripting	4	05-28-2008 08:02 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by