Help with awking

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

Hi...
How does awk or sed or even grep extract the following string out of my text file?.
'"${ETL_VW_SCHEMA}"'.IATA_STN_TZ_UTC_LCL_CONV_CV
'"${ETL_VW_SCHEMA}"'.CO
'"${ETL_VW_SCHEMA}"'.TEST_CO

I just need to extract the second entry which means I need to let awk know I am just searching for CO and not any combinations(like TEST_CO and IATA_STN_TZ_UTC_LCL_CONV_CV) and with the occurence of ETL_VW_SCHEMA...so, basically I need to search for '"${ETL_VW_SCHEMA}"'.CO
For some reason my awk doesn't recognize the period(.) in my search pattern.

Thx !

vgersh99 · #2 (**permalink**) 02-24-2009

Code:

$ nawk '/'"${ETL_VW_SCHEMA}"'.TEST_CO/' myFile.txt
'"${ETL_VW_SCHEMA}"'.TEST_CO
$ egrep ''"${ETL_VW_SCHEMA}"'.TEST_CO' myFile.txt
'"${ETL_VW_SCHEMA}"'.TEST_CO

anduzzi · #3 (**permalink**) 02-24-2009

Thanks for the reply !
I am on Solaris and these commands quite not working as expected.

Code:

bash-2.03$ egrep ''"${ETL_VW_SCHEMA}"'.CO' my.dat
'"${ETL_VW_SCHEMA}"'.IATA_STN_TZ_UTC_LCL_CONV_CV
'"${ETL_VW_SCHEMA}"'.CO
'"${ETL_VW_SCHEMA}"'.TEST_CO

Code:

bash-2.03$ nawk '/'"${ETL_VW_SCHEMA}"'.CO/' my.dat
'"${ETL_VW_SCHEMA}"'.IATA_STN_TZ_UTC_LCL_CONV_CV
'"${ETL_VW_SCHEMA}"'.CO
'"${ETL_VW_SCHEMA}"'.TEST_CO

I get all the occurences !

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

Escaping the period works.

Code:

awk '/\.\CO/' my.dat
'"${ETL_VW_SCHEMA}"'.CO

vgersh99 · #5 (**permalink**) 02-24-2009

you probably want this:

Code:

awk '/[.]CO$/' my.dat
'"${ETL_VW_SCHEMA}"'.CO

anduzzi · #6 (**permalink**) 02-24-2009

Thx this works !

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Awking	anduzzi	Shell Programming and Scripting	3	02-09-2009 01:37 PM
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