I use the same backup product that initially produced this file.. Instead of pulling stuff from the actlog directly with sql, use the "q actlog" command, and then put it out to a file with the -comma argument. Then, here's your code to make some sense of the jumble. it's also good just to dump the actlog because there is a lot of other relevant info in there that you'll be wanting sooner or later. err.. better yet, just pull it down from my.adsm.org, it's the daily backup status tool, I put a new one up there a few days ago, I don't know if it's made it all the way to to my.adsm.org yet, In the event that you have some objection to that site, you can pull it straight from my website. http://www.warispeace.org/tsm/dailybackupstatus.tar.gz or if you want the new one ( and you probably do, it is much improved ) http://www.warispeace.org/tsm/new-dbs.tar.gz at least it will dump a LOT of relevant info into your DB of choice ( it's setup for mysql, but it uses DBI, so you can change it whatever you prefer ). Enjoy!

In reply to Re: Assistance with Comma parse by Anonymous Monk
in thread Assistance with Comma parse by dbrock

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.