Well I am not an expert in reg ex.
But I would set soming like
(anything followed by 2 numbers with exact expression "-04-" followed by 4 numbers followed by anything) or (anything followed by 4 numbers with exact expression "-04-" followed by 2 numbers followed by anything)

my tentative:
[0-9][0-9]-04-[0-9][0-9][0-9][0-9]|[0-9][0-9][0-9][0-9]-04-[0-9][0-9]

Not sure this makes sence.
Note: this is my first tentative for a regex expressoion 😯

Br
Jf

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

I haven’t tested this yet in Tabbles but have run it through the tool Espresso which is good for testing regex.

d{2}-04-d{4}

It is matching 2 digits then the -04- for April and finally 4 digits for the year. Should work for you as i don’t think error checking needs to be done on the day/year part of the match.

Sorry i just reread what you were after and i see i should tweak this some more.

(?:w*_)?d{2}-04-d{4}(?:_w*)?

😀 Hope it works in Tabbles as it’s going fine in Espresso. I have to go Zzzz so will test it when i wake up in Tabbles.

Cool!

"nefycee" wrote:

(?:w*_)?d{2}-04-d{4}(?:_w*)?

This one works, thanks! 😀

Great! You will find that it matches Name_27-04-10_Name too but i hope that won’t matter 😉

Hi.
I will be very grateful if someone can explain to me or create a regular expression, that reads the metadata of the author field in the word documents, so that I can label them by authors, subject, content, state, comment, episode, etc.

The author is the one that interests me most.
Thank you so much.