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

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

We use technology (including cookies) to collect, use and transfer information to support this Site, including for data analytics purposes, as described in this Site's updated Privacy Policy. Your continued use of the Site signifies your acceptance of such cookies. To learn more about how to manage your cookie settings and how to exercise your rights under GDPR please see our Privacy Policy

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