UNIX for Dummies Questions & Answers

Folks;
I'm writing a script to extract fields from a log file then export the results to Excel sheet. I need help ASAP.

Here's a sample of the log file with "|" as a delimiter:

2007-07-27 09:24:41,838|ViewAttachmentsAction|New Value|ptcRV|03 Practice Design|brobitaille|brobeee|brobe|brobe@nec.com


2007-07-23 14:28:51,674|ViewPageAction|Technical Community|AddedCommunity|Case_Study|mwhite|Rostle|pda_advise|groups@nec.com

What is your question?

Sorry my thread wasn't clear.
I want help on how to create a script that extract the fields from a log file & export them to an Excel sheet?

Why don't you FTP the file the way it is and import into Excel specifying
vertical bar "|" as field delimiter?

i need to get the specific lines that related to the topic i need because there's other data in the log file that i don't need then after the extraction, i can export it Excel.

what i need is the fields in the lines that i've mentioned in the beginning of the thread

Moe,
Please be very specific on the criteria you want to extract records from the file.

I am still not clear on your requirement.

Please give a sample of several different records and what criteria do you want
to extract the data.

Ok;
let's say I want to extract every line from the log file that related to "Real Value" space & as you see from the log line i have below, there's a few fields i want to extract like "date, real value, last editor & edit's e-mail"
and whatever i extract, i want to export into Excel sheet.

2007-07-22 14:46:46,393|ViewPageAction|Real Value|ptcRV| Infrastructure|first editor|last editor|editor_id|editro's e-mail