regular expression request 2012-07-05T05:51:40+00:00

Home Forums Help needed regular expression request

  • Author
    Posts
  • nefycee
    Participant
    Post count: 143

    I search an expression for my folders named named after date

    23-04-2010 or Name_23-04-2010 or 23-10-2010_Name

    Now I want a regex for the tabble "april" and it should only match these three kinds of folders ๐Ÿ˜•

  • Jfw
    Participant
    Post count: 36

    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

  • Andrea
    Keymaster
    Post count: 893

    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? ๐Ÿ˜€

  • KaptK
    Participant
    Post count: 22

    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.

  • nefycee
    Participant
    Post count: 143

    "KaptK" wrote:

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

    This one works, thanks! ๐Ÿ˜€

  • Andrea
    Keymaster
    Post count: 893

    Cool! :mrgreen:

  • KaptK
    Participant
    Post count: 22

    "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 ๐Ÿ˜‰

You must be logged in to reply to this topic.

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