topic Re: use multiple field seperators with awk in Operating System - HP-UX

use multiple field seperators with awk

renarios — Fri, 20 May 2005 04:36:50 GMT

Hi all,

In a testcase, my /etc/oratab looks like this:
# Oracle 8 stuff (ocho)
tst1:/mnt/u01/app/oracle/product/8.1.7:Y
# Oracle 9 stuff (el nino)
tst2:/mnt/u01/app/oracle/product/9.2.0:Y
tst3:/mnt/u01/app/oracle/product/9.2.0:N

for a backup script I need all "active" Oracle 9i databases. I came up with this:
DBLIST=$(awk -F: '$1 !~ /^#/ && $3 ~ /Y$/ {print $1}' ${ORATAB})
, but that does only filter the "Y" and comment lines. How can I filter the "9" (and 10 later on) out of the lines?
Best would be use something with >8

I'm struggling with split, but I'm stuck
Any ideas?

Cheerio,

Renarios

Re: use multiple field seperators with awk

Sudeesh — Fri, 20 May 2005 05:01:45 GMT

Hello,

I just did what you have said....

[rx260-11]/sudhi >cat kk
# Oracle 8 stuff (ocho)
tst1:/mnt/u01/app/oracle/product/8.1.7:Y
# Oracle 9 stuff (el nino)
tst2:/mnt/u01/app/oracle/product/9.2.0:Y
tst3:/mnt/u01/app/oracle/product/9.2.0:N

[rx260-11]/sudhi >awk -F: '$1 !~ /^#/ && $3 ~ /Y$/ {print $1}' kk
tst1
tst2
[rx260-11]/sudhi >

and see only test1,test2 in the o/p

what you want to achive? am I missing something in your question?

Sudeesh

Re: use multiple field seperators with awk

renarios — Fri, 20 May 2005 06:01:29 GMT

Hi Sudeesh,

Thanks for the quick response.
The output should be only tst2, because tst1 is 8.1.7 and I only want the active 9.2.0 (or in future higher) databases.

thanks,

RenÃ

Re: use multiple field seperators with awk

renarios — Fri, 20 May 2005 07:18:35 GMT

Latest code is
awk -F: '$1 !~ /^#/ && $3 ~ /Y$/ && split($0, arr, "/") {if ( arr[7] > 8 ) print arr[7] "*" $1 " " $2 " " $3}' ${ORATAB}
, but it does not work.

Has anyone other/ideas ideas?

Cheers,

Renarios

Re: use multiple field seperators with awk

renarios — Fri, 20 May 2005 07:43:41 GMT

I found a solution:
awk -F: '$1 !~ /^#/ && $3 ~ /Y$/ && split($0, arr, "/") && split(arr[7], oraver, ".") {if ( oraver[1] >= 9 ) print $1}' ${ORATAB}

10 point for Renarios?

Only thing is: How do I get this readable?
If I use BEGIN and END, it doesn't work anymore.
Anyone ideas?

Cheerio,

Renarios

Re: use multiple field seperators with awk

Alex Lavrov. — Fri, 20 May 2005 07:51:43 GMT

Dont' make it readable, if it works, leave it as is and make a really good comment how it works.

Because when you try to rewrite things so they'll look simplier, you can put there some bugs.

Good comment on this line will be enough I think :)

Re: use multiple field seperators with awk

curt larson_1 — Fri, 20 May 2005 09:18:20 GMT

something a little more readable

awk -F: '$1 !~ /^#/ && $3 ~ /Y$/ {
split($0, arr, "/");
split(arr[7], oraver, ".");
if ( oraver[1] >= 9 ) print $1;
}' ${ORATAB}

Re: use multiple field seperators with awk

renarios — Fri, 20 May 2005 09:24:49 GMT

Thanks guys,

That should do the trick.
Time for weekend. Have one on me.

Solution:
DBLIST=$( awk -F: '$1 !~ /^#/ && $3 ~ /Y$/ {
split($0, arr, "/");
split(arr[7], oraver, ".");
if ( oraver[1] >= 9 ) print $1;
}' ${ORATAB} )

Cheerio,

Renarios