topic Re: getting fields to print in awk in Operating System - Linux

getting fields to print in awk

lawrenzo_1 — Tue, 31 Jul 2007 11:19:21 GMT

Guys can you help me with the following:

--> ./asm.ksh as_oracle

Report Run Date
--------------------------
31-JUL-2007 16:23:08

Server
---------------
heidegger

Disk Group Total Mb Free Mb
-------------------- -------- ---------
ASM_DATA 73728 20495
ASM_FLASH 110592 96233

the information i require is:

ASM_DATA,73728,20495
ASM_FLASH,110592,96233

so I have attempted the syntax:

awk 'NR>11 {if ($1~/ASM_DATA/) {OFS=",";print $1,$2,$3}}; {if ($1~/ASM_FLASH/) {OFS=",";print $1,$2,$3}}'

This does work however I want to know if this is the best code to run, as I am learning awk I want to ensure my knowledge is complete.

Thanks

Chris.

Re: getting fields to print in awk

Sandman! — Tue, 31 Jul 2007 11:24:55 GMT

# awk '/ASM_/ {for(i=1;i<=NF;i++) printf(i

Re: getting fields to print in awk

James R. Ferguson — Tue, 31 Jul 2007 11:30:21 GMT

Hi Chris:

Use a 'BEGIN' block to set your OFS; avoid the line-number check and simply match an either/or pattern:

# awk 'BEGIN{OFS=","};{if ($1~/ASM_DATA/||$1~/ASM_FLASH/) {print $1,$2,$3}}'

Regards!

...JRF...

Re: getting fields to print in awk

lawrenzo_1 — Tue, 31 Jul 2007 11:42:09 GMT

thanks chaps,

will will have a play with yours sandman :)

Chris

Re: getting fields to print in awk

lawrenzo_1 — Tue, 31 Jul 2007 11:44:46 GMT

Thanks again,

and I'll rephrase my last comment

I'll have a play with your code sandman!!

Chris

Re: getting fields to print in awk

Sandman! — Tue, 31 Jul 2007 12:45:52 GMT

Chris,

Thanks for trying the code I posted though the play on words escapes me ;)