topic Re: parsing data in Operating System - HP-UX

parsing data

Nick D'Angelo — Fri, 19 Oct 2001 14:26:29 GMT

I have the output from a cronjob to report on the size of tables in a db.

But if you look below, there are a number of tables that have 0 bytes (empty) and I want to remove them so that I only need to look at the tables with actual data in them.

Suggestions are always appreciated.

abs_mstr 0 0 0 0 0 0.0 0.0
accd_det 0 0 0 0 0 0 0.0 0.0
acd_det 48105 2531643 37 73 52 48105 1.0 3.8
acm_mstr 0 0 0 0 0 0 0.0 0.0
act_mstr 0 0 0 0 0 0 0.0 0.0
acx_mstr 0 0 0 0 0 0 0.0 0.0
ac_mstr 472 31355 47 73 66 472 1.0 5.7

Re: parsing data

James R. Ferguson — Fri, 19 Oct 2001 14:40:24 GMT

Hi Nick:

From the pattern of your data, this would do it:

# awk '$2>0 {print $0}' /tmp/filein > /tmp/fileout

Regards!

...JRF...

Re: parsing data

Robin Wakefield — Fri, 19 Oct 2001 14:43:27 GMT

Hi Nick,

How about:

grep [1-9] filename

Rgds, Robin

Re: parsing data

A. Clay Stephenson — Fri, 19 Oct 2001 14:44:31 GMT

Hi Nick:

Something like this:

cat infile | awk '{ if ((($2 + 0) > 0) || (($3 + 0) > 0)) print $0 }'

or pipe the output of your command to the awk. Note: The $2 + 0 forces the comparison to be numeric.

Clay

Re: parsing data

Sridhar Bhaskarla — Fri, 19 Oct 2001 15:09:59 GMT

Nick,

awk will help you to simplify this. You can print out only those lines that satisfy the condition on a particular (or a group of) column. If you want the second column (it is $2 in awk's parsing) to be determined as non-zero, you would give

awk '$2>0 {print $0}' your_file

-Sri

Re: parsing data

Lou Zirko_1 — Fri, 19 Oct 2001 15:17:18 GMT

Another method would be the grep below:

grep -v "0 0 0 0 0 0.0 0.0" filename

This will print all lines that do not have a "0 0 0 0 0 0.0 0.0" pattern in them.

Lou Zirko

Re: parsing data

Nick D'Angelo — Fri, 19 Oct 2001 15:32:09 GMT

Thanks for all the solutions.

issue closed.