regular expression

#!/usr/bin/python
import re
import os
import win32com.client

paymentmsg = "Hej 2 Jval01eff2rTEST01ey 1200,00 kr. +test2 +71<066825614704683+86870762Betalingsdato 18-07-2017"

# Delete Python-style comments
#num = re.sub(r'#.*$', "", phone)
#print ("Phone Num : ", num)

# Remove anything other than digits
#num = re.sub(r'\D', "", phone)  
#print ("Phone Num : ", num)

# Remove anything other than digits
#num = re.sub(r'\D', "", phone)  
#print ("Phone Num : ", num)

#phone1 = "xxx Your number is <b>123</b>  fdjsk"
#Clean the message for easier identifying elements
paymentmsg = paymentmsg.replace(" ", "")
paymentmsg = paymentmsg.lower()
#print (paymentmsg)

amount = re.search("(\d+\D\d+)kr", paymentmsg)
if amount:
    print (amount.groups()[0])
    #Store Beløb
    amountStr = (amount.groups()[0])
else:
    if amount2:
        amount2 = re.search("(\d+)kr", paymentmsg)
        print (amount2.groups()[0])
        #Store Beløb
        amountStr = (amount2.groups()[0])
   
OCR = re.search("\\+71<(\d+)", paymentmsg)
if OCR:
    print (OCR.groups()[0])
    #Store OCR
    ocrStr = (OCR.groups()[0])

paymentdate = re.search("(\d+-\d+-\d+)", paymentmsg)
if paymentdate:
    print (paymentdate.groups()[0])
    #Store Dato
    paymentdateStr = (paymentdate.groups()[0])

env = re.search("(val\d+)", paymentmsg)
if env:
    print (env.groups()[0])
    #Store
    envStr = (env.groups()[0])
else:
    if env:
        env = re.search("(test\d+)", paymentmsg)
        print (env.groups()[0])
        #Store Miljø
        envStr = (env.groups()[0])


   

Kommentarer

Send en kommentar

Populære opslag fra denne blog

Xpath cheat sheet

Billede
This is  Cheatsheets  — a collection of cheatsheets I've written. Xpath All the tools your team needs in one place. Slack: Where work happens. ads via Carbon Descendant selectors h1 //h1 ? div p //div//p ? ul > li //ul/li ? ul > li > a //ul/li/a   div > * //div/*   :root / ? :root > body /body   Attribute selectors #id //[@id="id"] ? .class //[@class="class"]   … kinda   input[type="submit"] //input[@type="submit"]   a#abc[for="xyz"] //a[@id="abc"][@for="xyz"] ? a[rel] //a[@rel]   a[href^='/'] //a[starts-with(@href, '/')] ? a[href$='pdf'] //a[ends-with(@href, '.pdf')]   a[href~='://'] //a[contains(@href, '://')]   … kinda   Order selectors ul > li:first-child //ul/li[1] ? ul > li:nth-child(2) //ul/li[2]   ul > li:last-child //ul/li[last()]   li#id:first-child //li[@id="id"][1]  ...
Læs mere

Reading Email

#!/usr/bin/python import sys import re import os import win32com.client import win32api import win32con import datetime as dt import cx_Oracle from selenium import webdriver from selenium.webdriver.support.ui import WebDriverWait from selenium.webdriver.support import expected_conditions as EC from selenium.common.exceptions import TimeoutException from selenium.webdriver.common.by import By outlook = win32com.client.Dispatch("Outlook.Application").GetNamespace("MAPI") inbox = outlook.GetDefaultFolder(6) # "6" refers to the index of a folder - in this case,                                     # the inbox. You can change that number to reference                                     # any other folder messages = inbox.Items message = messages.GetLast() body_content = message.body subject_c...
Læs mere

pip whl install python

Go to C:\Python34\Scripts (this is the folder where pip.exe is locateD) run below in cmd: python - m pip install requests above will install lib: requests pip install some - package . whl Note: if pip.exe is not recognized, you may find it in the "Scripts" directory from where python has been installed. If pip is not installed, this page can help:  How do I install pip on Windows? Note: for clarification If you copy the  *.whl  file to your local drive (ex.  C:\some-dir\some-file.whl ) use the following command line parameters -- pip install C :/ some - dir / some - file . whl
Læs mere