Reply To: Re: regular expression request 2012-07-05T16:39:01+00:00

Home Forums Help needed regular expression request Reply To: Re: regular expression request

Andrea
Keymaster
Post count: 877

Hello guys!

We’ve just spent a week of "forced holidays"…we were both extremely burned-out 🙂
Anyway, back to your question, you may want to check this link: http://www.regular-expressions.info/dates.html.

The idea is that you should create a rule for each month and each year where you tell Tabbles: "whatever day, whatever year and the month of April -> put it in the tabble "April". So,

.*[0-2][0-9].*|.*3[0-1].* = whatever day, followed or preceded by anything
.*2000|2001|2002|2003|2004|2005|2006|2007|2008|2009|2010|.* = whatever year from 2000 to 2010, followed or preceded by anything

.* = zero or more of any character
. = any character, only once (it works with the "-" that nefycee needs)

So, in nefycee’s example 23-04-2010 or Name_23-04-2010 or 23-10-2010_Name the expression for april may look like:

.*([0-2][0-9]|3[0-1]).04.(2000|2001|2002|2003|2004|2005|2006|2007|2008|2009|2010).*

That should work! Any volunteer to try this out? 😀

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close