Hi robdog,

Although I can't say I am perfectly clear on your specific requirements, this sounds at least roughly like a case where using a spreadsheet (ie MSFT Excel or OpenOffice Calc) would simplify your work.

A spreadsheet makes it easy to: do mass changes; validate for valid integer, string, or other formatted data; process statistical metadata; sort and so forth. In other words it has most of the wheels that one would want to avoid re-inventing. (Unless part of the excercise is the enjoyment of do-it-yourself, which is a valid consideration).

the hard part

The main problem, of course, is how to map arbitrary text files of any arbitrary syntax format into the neatly-arranged cells of a spreadsheet, and then *back* out to the arbitrary text files, once you are done 'munging' them in the spreadsheet. I've written some apps that allow me to 'munge' multiple text files into and out of Excel, but it is pretty specific to my own work.

I could not gather from your post: what language you are coding in; how you are persisting your objects; and whether you are directly manipulating text files. Therefore, your approach may be dissimilar from what I have done using spreadsheets.

Nonetheless, this general type of problem solving seems like a productive path to consider, as it does simplify many tasks. Therefore I'd be interested in whatever you're able to find that addresses your needs.

In reply to Re: DataGrid in Perl by dimar
in thread DataGrid in Perl by robdog

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.