问在电子邮件主题行中提取单词"for“和开括号"(”之间的单词。电子邮件主题行是输入
EN

Stack Overflow用户

提问于 2019-05-09 19:17:17

回答 1查看 91关注 0票数 0

客户的名字在"for“一词之后，在开括号"(”之前，它开始了建议书编号。我需要提取客户名称以用于在未来的步骤中查找交易。设置它的最简单方法是什么？使用Zapier提取模式还是在Python中使用Zapier代码？

我试过了，但它不起作用。不过，这看起来很有希望。

input_data

客户=提醒:Leruth已向您发送了一份业务名称建议书(#642931)

import regex
rgx = regex.compile(r'(?si)(?|{0}(.*?){1}|{1}(.*?)
{0})'.format('for', '('))
s1 = 'client'
for s in [s1]:
m = rgx.findall
for x in m:
print x.strip()

我也试过了，它不起作用。

start = mystring.find( 'for' )
end = mystring.find( '(' )
if start != -1 and end != -1:
result = mystring[start+1:end]

我正在寻找要在我的示例中返回的业务名称。

python

regex

zapier

云点播特惠1元起

提供三端 SDK 、云 API、控制台等多种上传方式，弱网环境下文件上传成功率达到 99.5%

回答 1

Stack Overflow用户

回答已采纳

发布于 2019-05-09 20:00:31

最快的方法：

start = client.find('for')
end = client.find('(')
result = client[start+4:end-1]
print(result)

使用正则表达式：

result = re.search(r' for (.*) [(]', client)
print(result.group(1))

可能有一种更简洁的方法可以做到这一点，但这里有另一种不使用正则表达式的解决方案。

client = "Reminder: Leruths has sent you a proposal for Business Name (#642931)"

cs = client.split(" ")
name = ""
append = False
for word in cs:
    if "for" == word:
        append = True
    elif word.startswith("("):
        append = False
    if append is True and word != "for":
        name += (word + " ")
name = name.strip()
print(name)

另一种方法：

client = "Reminder: Leruths has sent you a proposal for Business Name (#642931)"

cs = client.split(" ")
name = ""
forindex = cs.index("for")

for i in range(forindex+1, len(cs)):
    if cs[i].startswith("("):
        break
    name += cs[i] + " "
name = name.strip()

print(name)

运行以下代码会得到以下结果：

Regex method took 2.3912417888641357 seconds
Search word by word method took 4.78193998336792 seconds
Search with list index method took 3.1756017208099365 seconds
String indexing method took 0.8496286869049072 seconds

代码检查获得超过一百万次尝试的名称的最快速度：

import re
import time

client = "Reminder: Leruths has sent you a proposal for Business Name (#642931)"

def withRegex(client):
    result = re.search(r' for (.*) [(]', client)
    return(result.group(1))

def searchWordbyWord(client):
    cs = client.split(" ")
    name = ""
    append = False
    for word in cs:
        if "for" == word:
            append = True
        elif word.startswith("("):
            append = False
        if append is True and word != "for":
            name += (word + " ")
    name = name.strip()
    return name

def searchWithListIndex(client):
    cs = client.split(" ")
    name = ""
    forindex = cs.index("for")

    for i in range(forindex+1, len(cs)):
        if cs[i].startswith("("):
            break
        name += cs[i] + " "
    name = name.strip()

    return name

def stringIndexing(client):
    start = client.find('for')
    end = client.find('(')
    result = client[start+4:end-1]
    return result

wr = time.time()
for x in range(1,1000000):
    withRegex(client)
wr = time.time() - wr
print("Regex method took " + str(wr) + " seconds")

sw = time.time()
for x in range(1,1000000):
    searchWordbyWord(client)
sw = time.time() - sw
print("Search word by word method took " + str(sw) + " seconds")

wl = time.time()
for x in range(1,1000000):
    searchWithListIndex(client)
wl = time.time() - wl
print("Search with list index method took " + str(wl) + " seconds")

si = time.time()
for x in range(1,1000000):
    stringIndexing(client)
si = time.time() - si
print("String indexing method took " + str(si) + " seconds")