I'm trying to create a search engine for a CSV file of phone numbers. Each line in the CSV is a number, with the City, State and Area Code it's in. I can easily create a search for any of those fields individually or all of them if they're all filled in but I can't search for say, City and State with the Area Code field blank. If I fill in City and State, I want all the hits from the file that are a City with that name in the specified State, whatever Area Code it might be in. Or if I just fill in the Area Code, I want all numbers in that Area Code. I'd post code but I only have the basic split the line ,match the input to the value, if it matches push the line into an array for later printing. I'm sure this is an easy problem, but for some reason I can't find the answer. I'm not opposed to using DBI but I figured there has to be an easier way. Thanks in advance.

In reply to Search CSV for multiple parameters by Indomitus

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.