laziness, impatience, and hubris | |
PerlMonks |
Re: Excel Reports thru CGIby cbro (Pilgrim) |
on Aug 21, 2003 at 14:14 UTC ( [id://285475]=note: print w/replies, xml ) | Need Help?? |
To give you an exact answer, I think a little more specifics on what matching criteria you are going to allow is necessary. (e.g. you say that the user can enter 3 as the year. Does that mean that the only number the user can enter for the year, other then the exact year string, is the number that the year ends in? Or, can they enter '2' because that is also a number in the year 2003). But, at least to get you started... 1. Read in your users' entries via the param() method. 2. Split your date (which is what I think may be your main concern) like this: my ($month, $day, $year) = split(/\-|\//, $date); Where $date is your Excel spreadsheet date. 3. Finally, and this is where I would need some more specifics, do a regex to match the users data to your split $date. Just an example:
In Section
Seekers of Perl Wisdom
|
|