topic Re: awk report help in Operating System - HP-UX

awk report help

Junior C. — Mon, 04 Aug 2008 13:03:43 GMT

All,
I'm trying to print a report from a text file using awk. Following is an example of my current output.

Application1: Application2: Application3:
tes1 test2 test3
test1 test2 test3
test2 test3
test2 test3

Following is the output I would like to have.

Application1: Application2: Application3:
tes1 test2 test3
test1 test2 test3
test2 test3
test2 test3

I appreciate all help.

Thanks,

JC

Re: awk report help

James R. Ferguson — Mon, 04 Aug 2008 13:08:05 GMT

Hi JC:

So where's the *input*? You current output looks like the desired output, too!

Regards!

...JRF...

Re: awk report help

Junior C. — Mon, 04 Aug 2008 13:44:29 GMT

...JFR...

The format did not display correctly.

Output I'm looking for excluding the (.....)

Apps1: Apps2: Apps3:
test1 test2 test3
test1 test2 test3
.......test2 test3
.......test2 test3
.......test2 test3
.............test3
.............test3

Thanks,

JC

Re: awk report help

James R. Ferguson — Mon, 04 Aug 2008 13:49:41 GMT

Hi (again) JC:

You still haven't provided the *input*. A sample or attachment is needed.

Regards!

...JRF...

Re: awk report help

Dennis Handly — Mon, 04 Aug 2008 13:58:16 GMT

>The format did not display correctly.

Yes, leading and multiple blanks are stripped unless you check the "Retain format" box.
You still may have to attach some files.

>Output I'm looking for excluding the (.....)

You want to indent your output?

Re: awk report help

Junior C. — Mon, 04 Aug 2008 14:30:13 GMT

...JRF...

Attach txt file have the output format I'm looking for.

Each column is a separate file that I combine and want to generate one report.

Thanks,

JC

Re: awk report help

James R. Ferguson — Mon, 04 Aug 2008 15:21:13 GMT

Hi JC:

> Each column is a separate file that I combine and want to generate one report

It appears that a simple 'paste' will accomodate your neeeds:

# paste -d" " file1 file2 file3

...or if you like well-formatted output:

# pr -t -m file1 file2 file3

Regards!

...JRF...

Re: awk report help

Peter Nikitka — Mon, 04 Aug 2008 15:38:50 GMT

Hi,

my solution assumes
- the first line of input is a header line, which defines the total number of columns and the width of its columns
- columns may be of differnt sizes
- if the number of fields in a column is less than the header line defines, they get filled from column 1 on.
- I use a dot as filler, to get a better readable output here - just change
gsub(".",".",filler[i])
to
gsub("."," ",filler[i]) to get spaces.
as well as
...=out[num-NF+i]"."
to
...=out[num-NF+i]" "

awk 'NR==1 {for(i=1;i<=NF;i++) {filler[i]=$i;gsub(".",".",filler[i])}
num=NF; print; next}
{if(! NF) {print;next}
for (i=NF;i>0;i--) {out[num-NF+i]=$i; for(k=length(filler[i])-length($i);k;k--)out[num-NF+i]=out[num-NF+i]". "}
for(j=1;j<=num-NF;j++) out[j]=filler[j]; for(i=1;i
of
cat your-infile
Application1: Applicati2: Applica3:
test1 test2 test3
test1 test2 test3
test2 test3
test2 test3
test3

leads to
Application1: Applicati2: Applica3:
test1........ test2...... test3....
test1........ test2...... test3....
............. test2...... test3....
............. test2...... test3....
............. ........... test3....

mfG Peter