Sorry about the delay. I took Friday and Monday off (and was already gone by the time you responded). I DO NOT touch computers when I take vacations. I 'msg' you on CB in case you don't read this.
I need the match criteria. That is, what will you allow the user to enter in order to consider his or her data to match against a date listing in your spread sheet. Here are just some questions to give you an idea of what I'm trying to get at.

The user can enter one digit to match the year, according to your OP. So, if they don't enter the exact year, must that one digit be the last digit of the year? Or if they enter '03' should that match 2003? Or if they enter '2', should that match 2003 (because it's the first digit of the year) or only 2002? What about 20? etc....

You said they can enter '8' for the month to match August. What if they enter '1'? Should that only match January? Or, should it match '11', '12', '10'?
This is what I need to know to come up with the regex.
I have a feeling when you go through and make all of those decisions...you'll be able to come up with the regex yourself :o).

As far as filtering...I'll answer that when you either tell me that you have the regexes, or when I attempt to help you with them.

Thanks,
Chris

In reply to Re: Re: Re: Excel Reports thru CGI by cbro
in thread Excel Reports thru CGI by rupesh

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.