|Just another Perl shrine|
Re: Re: Re: Excel Reports thru CGIby cbro (Pilgrim)
|on Aug 26, 2003 at 13:33 UTC||Need Help??|
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.