UNIX for Dummies Questions & Answers

Yes.
If this is not possible, how can i export the intermediate file into Excel?

This was answered already in the previous replies.

Did you get a chance to look at those ?

awk <command> sourcefile > destfile

open destfile from excel with " | " as delimiter
you would achieve what you are looking for.

I do OK with scripting, but when it comes to excel file loading and stuff like that, I have no clue. However, I use such a script to get really great XLS files with pretty graphs, which is awesome in presentations.

Look into "Nmon Analyzer" it is a free tool to convery nmon output to pretty XLS file with graphs and stuff. It is primarily writte for AIX, but once you have the perl script, you might be able to borrow their idea on how to script.

Good luck

-GGR

Thanks;
If i use your commands to extract the fields i need to another file which i can open using Excel. That's great. But how can i use your script to add names to these fields so when i open it using Excel i can see the column names on the top.
for example:
when using your script, let's say the results will be like this

07:27:2007 Moe John moe@moe.com

where:
Moe: is the last person who viewed the page
John: Is the last person edited the page
moe@moe.com: is the e-mail for the last person viewed the field.

Now, I'd like the output of the extract to include the description of each field so when i open it using Excel i see on the top what's the field belong to. in other word, what can i add to the script to always include the description on the top of the results?

Thanks a lot folks.

Code:

awk -F"|" '/Real value/ { print $1, $4, $5 }' sourcefile > destfile

will transform to ( by adding the BEGIN block )

Code:

awk -F"|" 'BEGIN{printf "%s %s %s\n", "last_person_view", "last_person_edit", "mailId"} /Real value/ { print $1, $4, $5 }' sourcefile > destfile

I tried that but it didn't do it. still not bold

How can i limit the characters per field