Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

Re: Re: Re: Excel Reports thru CGI

by cbro (Pilgrim)
on Aug 26, 2003 at 13:33 UTC ( #286705=note: print w/replies, xml ) Need Help??

in reply to Re: Re: Excel Reports thru CGI
in thread Excel Reports thru CGI

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'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.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://286705]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (5)
As of 2018-06-25 17:45 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (128 votes). Check out past polls.