Databases
StackOverflow2013
Postsdbo
PORegex not working locally though working in every online regex tester
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORegex not working locally though working in every online regex tester
    primarykey
    data
    text
    <p>I am doing a small script, which should read my worked time from my email and save how much time I already worked. It is doing this through regex. Now here is my Script:</p> <p>import imaplib import re from pprint import pprint</p> <pre><code>mail = imaplib.IMAP4_SSL('imap.gmail.com',993) mail.login('*************', '**************') # Out: list of "folders" aka labels in gmail. mail.select("inbox") # connect to inbox. typ, data = mail.search(None, 'SUBJECT', 'Zeiterfassung') worked_time_pattern = re.compile(r'"(?P&lt;time&gt;\d+(,\d)?)"[^&gt;]*?selected[^&gt;]*&gt;=?(\r?\n?)(?P=time)&lt;') # old version: worked_time_pattern = re.compile(r'\"(?P&lt;time&gt;[0-9]+(?:[,][0-9])?)\"(?: disabled)? selected(?: disabled)? style=3D""&gt;[=]?[\n]?(?P=time)&lt;\/option&gt;') date_pattern = re.compile('.*Date: [a-zA-Z]{1,4}[,] (?P&lt;date&gt;[0-9]{1,2} [a-zA-Z]{1,4} [0-9]{4}).*', re.DOTALL) count = 0 countFail = 0 if 'OK' == typ: for num in data[0].split(): typ, data = mail.fetch(num, '(RFC822)') mailbody = "".join(data[0][1].split("=\r\n")) mailbody = "".join(mailbody.split("\r")) mailbody = "".join(mailbody.split("\n")) worked_time = worked_time_pattern.search(data[0][1]) date = date_pattern.match(data[0][1]) if worked_time != None: print worked_time.group('time') count = count + 1 else: print mailbody countFail = countFail + 1 print worked_time print "You worked on %s\n" % ( date.group('date')) #print 'Message %s\n%s\n' % (num, data[0][1]) print count print countFail mail.close() mail.logout() </code></pre> <p>the problem is, it returns <code>None</code> for worked_time for some of my strings (not all, more than a half works [23 works, 8 not]), which means that the pattern is not matched. I tested it with most online regex testers, and they all told me, that the pattern matches and everything fine..</p> <p>here a few example strings that weren't accepted but are by online tools, e.g. <a href="http://regex101.com" rel="nofollow">http://regex101.com</a></p> <p>pasted them, because it they are big and ugly: <a href="http://pastebin.com/4Z2BdmXk" rel="nofollow">http://pastebin.com/4Z2BdmXk</a> <a href="http://pastebin.com/dMxcRqQu" rel="nofollow">http://pastebin.com/dMxcRqQu</a></p> <p>btw the regex for date works fine on all (but not on the pasted string I had to cut away the upper part because of a lot of private information)</p> <p>worked_time_pattern should search for something like: <code>"1,5" disabled selected style=3D""&gt;1,5&lt;/option&gt;</code> (and get the <code>1,5</code> out of it, exaclty as it does on half of the cases...)</p> <p>Anybody any idea?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USkave
    1. USkave
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PORegex not working locally though working in every online regex tester
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PORegex not working locally though working in every online regex tester
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't know if that is the problem, but you should probably use raw strings for regex, i.e. `re.compile(r'my regex here')`. Notice the "r" before the string.
      singulars
      1. PORegex not working locally though working in every online regex tester
      1. USrantanplan
    2. COI just tested both pastebins in the python interpreter and both matches were found. Since I was pasting it into the interpreter I only pasted in from the start of the select field (since there are no line breaks after that).
      singulars
      1. PORegex not working locally though working in every online regex tester
      1. USOGHaza
    3. CO@rantanplan thanks, I changed that but didn't help me :/
      singulars
      1. PORegex not working locally though working in every online regex tester
      1. USkave
 

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