Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Parsing a non-formatted record text file

by Narveson (Chaplain)
on Feb 16, 2009 at 16:30 UTC ( [id://744124]=note: print w/replies, xml ) Need Help??


in reply to Parsing a non-formatted record text file

Your boss doesn't seem to have given you a formal statement of requirements. That's good news for you: it means you're needed.

Take a reasonable sample of your data (perhaps slightly larger than you posted here) and manually transcribe it as a CSV file. You will start to notice you have some choices to make.

Do you want to keep all the data you see? You've told us you don't. So you probably have a finite list of fields to be recorded. Put that list in your column headings.

A first approximation to your column headings might be Timestamp, LoadAvg1, LoadAvg2, LoadAvg3, SleepingProcesses, RunningProcesses and whatever else you know to be of interest.

Alternatively, your boss may want a taller, narrower list containing dated name-value pairs. Your guess is better than mine.

Give the boss your manually transcribed CSV file and ask "Is this what you need?"

If the answer is yes, the rest is a simple matter of programming.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://744124]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2024-03-29 12:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found