>I'm trying to grasp Matt's concept of a "pattern" field. How you would >parse it actually, I understand patterns, just not how to allow for as >many variables as could exist with plain English as opposed to some type >of codes. > >Matt, if you've got any more in-depth info on how you parse a pattern >like: "First Monday of January from 2003 to 2015 Except January 14 2008 >which will be rescheduled to January 15 2008" then I'd appreciate a >glimpse into how you're accomplishing that.
There is logic in the pattern concept. That's what standards like ISO 8601/RFC 2445 were built for. Though I don't know if/and what kind of parser exists for it. For example (taken from http://www.idealliance.org/papers/xml2001/papers/html/05- 04-06.html ) The 3rd instance into the month of one of Tuesday, Wednesday or Thursday, for the next 3 months: DTSTART;TZID=US-Eastern:19970904T090000 RRULE:FREQ=MONTHLY;COUNT=3;BYDAY=TU,WE,TH;B YSETPOS=3 Nasty looking rule, but there's a whole slew of standards, exceptions, notations, etc to describe everything from gregorian to julian to japanese calendar dates. Also, I think ISO 8601-2000 Draft has a set of rules and notations that's even more compact (all though barely human readable at all) Drop a recurrence rule or pattern in one column, find (or make) a parser for it based on reverse enginering the specs, and voila. Erik Yowell [EMAIL PROTECTED] http://www.shortfusemedia.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
