Depends on what you're trying to do with those SQL's, doesn't it? If all you're doing is selecting certain records based off values or value ranges, then it's a simple matter of going through the file line by line, pattern matching out the data into fields, and then matching against those fields. If on the other hand you need to add or remove records from anywhere except the very end of the file, then you have a problem. One easy solution would be to rent some cheap mySQL hosting, export your data over there, and query against it, rather than trying to do all the heavy lifting on your machine.

In reply to Re: SQL Query a Non-CSV Flat File - Any Suggestions? :S by TedPride
in thread SQL Query a Non-CSV Flat File - Any Suggestions? :S by muyprofesional

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.