topic Re: Script output in table format in Operating System - HP-UX

Script output in table format

Starrynight — Thu, 20 Feb 2003 15:38:57 GMT

Hi everybody

I got a script that gives a lot of numeric output and now I want to put in table format....I just don??t know how!!! Is this possible to do?
If so...how can I do it?
I am really lost here...

Thanks in advance
SN

Re: Script output in table format

James R. Ferguson — Thu, 20 Feb 2003 15:58:53 GMT

Hi:

The easist way is to use formatted printing with 'printf'. See the man pages for more information.

Regards!

...JRF...

Re: Script output in table format

Kent Ostby — Thu, 20 Feb 2003 16:01:06 GMT

You can use awk to format your output depending on how predictable the output data is.

If you tell me what the output looks like now and what you'd like it to look like, I can help you out.

Re: Script output in table format

Ralph Grothe — Thu, 20 Feb 2003 16:50:12 GMT

If you already have a shell script I'd also think that a little extension that uses the printf command as already suggested would be the quickest solution.

If you have ever coded in C (or any syntactic C-alikes like Java, Perl, awk, Python etc.) you know how to use it.

On the other hand this is a true job for Perl (remember its acronym originally stood for "Practical Reporting and Extraction Language", though we all know that it stands for "Pathologically Eclectic Rubbish Lister").
See, the emphasis used to be on report generation.
For anything having to do with parsing, formatting, filtering text Perl to the rescue.

Re: Script output in table format

Chris Vail — Thu, 20 Feb 2003 17:00:27 GMT

The others comments about PERL, C and printf are all good. However, I suggest using echo statements, with either tab characters or commas between fields. The tab characters are crude, but they often work. The commas are good because you can then save your work with a .csv extension and open your document with Excel or some other spreadsheet program.

The command echo "$DATA1,$DATA2">>FILE is all you need. Then attach the file as a MIME compliant document with "uuencode FILE FILE|mailx -s "My subject" me@myplace.com. When it shows up in your email, just double-click on the attachment, and it will automatically open up in Excel.

Of course, this assumes that you have email working......if not, just ftp the document to your workstation, then double click.

Chris

Re: Script output in table format

Francisco J. Soler — Thu, 20 Feb 2003 17:44:36 GMT

Hi, SN

If you want HTML format in the output you can do this very easily wiht the tags

and .

Frank.

Re: Script output in table format

Starrynight — Fri, 21 Feb 2003 11:34:20 GMT

Hi all

I solved my problem with echo and printf.
Thank you all.

SN