in reply to Processing a file into mySQL and writing a results file
1) directory globs, for finding out what matching files exist
2) open(), to read the log file and the data file
3) DBI, to insert into the database
What level of programming experience (and specifically, Perl) do you have? In any case, I think your first step should be to re-write your bullet points above in a more logical, mechanical way. Then the job is just to translate them into Perl (easy, ain't it? :-) If you don't feel you can attempt writing the actual code just yet, post pseudocode and we'll take it from there.
Incidentally, if there are only three digits, you're going to loop after 41 days running. Will that be a problem?
|
|---|