Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You didn't mention <a href="http://docs.python.org/library/re.html#re.findall" rel="nofollow"><code>re.findall()</code></a> in the list of things you tried. That gives you a list of all regex matches. </p> <p>However, you need to use all non-capturing groups <code>(?:...)</code>, or you'll get a list of all matched groups <code>(...)</code>. Therefore, I suggest</p> <pre><code>pattern = """ (?:September|April|June|November) ,[ ] (?:0?[1-9]|[12]\d|30) ,[ ] (?:19|20)\d\d # Months with 30 days | (?:January|March|May|July|August|October|December) ,[ ] (?:0?[1-9]|[12]\d|3[01]) ,[ ] (?:19|20)\d\d # Months with 31 days | February ,[ ] (?: (?:0?[1-9]|1\d|2[0-8]) ,[ ] (?:19|20)\d\d | 29 ,[ ] (?: (?:19|20) (?:04|08|12|16|20|24|28|32|36|40|44|48| 52|56|60|64|68|72|76|80|84|88|92|96) | 2000 ) ) # February with 28 days or 29 with a leap year""" </code></pre> <p>But do you really need to validate the correctness of the dates? Are you expecting false dates like <code>February, 31, 2000</code> to turn up in your data? If not, you could simplify your regex enormously. Or at least delegate date validation to a date parsing function which is better equipped for this task than a monstrous regex.</p> <p>For example:</p> <pre><code>pattern = """ (?:January|February|March|April|May|June| July|August|September|October|November|December) ,[ ] [0-3]?\d ,[ ] (?:19|20)\d\d """ </code></pre> <p>matches nonsense like <code>January, 0, 1999</code> or <code>February, 31, 2000</code>, but would it really matter?</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I put all the strings that match my regular expression into a list in Python?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USTim Pietzcker
    1. USTim Pietzcker
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I put all the strings that match my regular expression into a list in Python?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 "monstrous regex"
      singulars
      1. PO
      1. USJohn Machin
    2. COI did use findall() but it didn't work. Turns out that the modifications you made to my expression did the trick. I got the "?:" operator from the answer to another question of mine and even after reading the documentation for it I wasn't entirely sure of what it did. Thanks for your help!
      singulars
      1. PO
      1. USahabos
    3. CO@Ivan: Great, but I'm finding that February, 29, 2012 isn't matched as it should be. I'm currently trying to sift through the wreckage and find a solution...
      singulars
      1. PO
      1. USTim Pietzcker
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload