ash0404 has asked for the wisdom of the Perl Monks concerning the following question:

This node falls below the community's minimum standard of quality and will not be displayed.

Replies are listed 'Best First'.
Re: Copy to Excel spreadsheet
by talexb (Chancellor) on Jan 18, 2005 at 20:52 UTC

    For parsing logs: Apache::ParseLog may work for you, or you may have to write something from scratch. That's not too onerous.

    For writing data into an Excel Spreadsheet: Spreadsheet::WriteExcel.

    Next time, I strongly recommend you show us how far you got, and which approaches you tried. To wax poetic for a moment, we're happy to help push you out of a ditch, but we're not going to teach you how to drive.

    Alex / talexb / Toronto

    "Groklaw is the open-source mentality applied to legal research" ~ Linus Torvalds

    A reply falls below the community's threshold of quality. You may see it by logging in.
Re: Copy to Excel spreadsheet
by dragonchild (Archbishop) on Jan 18, 2005 at 19:38 UTC
    What have you tried? What operating system? What language?

    Being right, does not endow the right to be rude; politeness costs nothing.
    Being unknowing, is not the same as being stupid.
    Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
    Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Re: Copy to Excel spreadsheet
by Anonymous Monk on Jan 18, 2005 at 19:45 UTC
  • Start | Run | Notepad
  • File | Open | Locate and open the log file.
  • Locate the block of text to copy and select it.
  • Ctrl-C (Copy)
  • Open up Excel.
  • Ctrl-V (Paste)
Re: Copy to Excel spreadsheet
by holli (Abbot) on Jan 18, 2005 at 20:08 UTC
    You might have a particular feeling to post your particular code inside particular <code></code>-tags, along with particular sample-data and a clarification of your particular formats.

    particularly thanks,
    holli, regexed monk
Re: Copy to Excel spreadsheet
by jcoxen (Deacon) on Jan 18, 2005 at 20:26 UTC
    RTFM where M = Camel Book is a good place to start.

    Jack

Re: Copy to Excel spreadsheet again
by Errto (Vicar) on Jan 19, 2005 at 02:05 UTC
    It looks like your original question was something different from what it now appears to be, because right now the replies from Anonymous Monk and talexb appear to be total non-sequiturs. Please put it back.