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

Andrea
Keymaster
Post count: 961

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