Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

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


Comment on Re: Re: Re: Excel Reports thru CGI

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://286705]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2014-09-23 02:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (210 votes), past polls