我正在尝试从一封电子邮件中提取我的银行余额号码到Google Spreadsheets中。到目前为止，我有一个Google脚本来抓取电子邮件，然后将其粘贴到原始内容形式的Google电子表格中。您可以在下面看到正在粘贴的RawContent。（这不是我的银行余额或银行卡，它是一个模板，已从我的银行的网站上使用并从该网站上取下来，以显示电子邮件的外观。）
MIME-Version: 1.0
Received: by 10.79.112.196 with HTTP; Tue, 20 Oct 2015 18:13:30 -0700 (PDT)
Date: Wed, 21 Oct 2015 02:13:30 +0100
Delivered-To: [email protected]
Message-ID: <CAL9nrMo3OXzMsPUMpXjOO1AEg_u72czoYLEQLeWz [email protected]>
Subject: BB TEST
From: Liam Nagle <[email protected]>
To: Liam Nagle <[email protected]>
Content-Type: multipart/alternative; boundary=001a114d944e1c2fac052293164b
--001a114d944e1c2fac052293164b
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Dear Mr. Broe,
Your weekly account summary for
account ending 6920 is below:
Current Balance as at 12:30 26 Sep:
=C2=A32500.00+
Available Balance as at 12:30 26 Sep:
=C2=A32700.00+
RECENT TRANSACTIONS:
25Sep Transfer =C2=A310.59-
25Sep Cheque deposit 150.00+
24Sep Direct Debit =C2=A33.60-
23Sep Standing order =C2=A323.50-
21Sep CC payment =C2=A349.00-
Regards,
Santander Alerts
--001a114d944e1c2fac052293164b
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><span style=3D"color:rgb(102,102,102);font-family:Verdana,=
Arial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-=
height:17.9952px">Dear Mr. Broe,</span><br style=3D"margin:0px;color:rgb(10=
2,102,102);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px=
;letter-spacing:-0.1104px;line-height:17.9952px"><br style=3D"margin:0px;co=
lor:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,sans-serif;font-si=
ze:11.04px;letter-spacing:-0.1104px;line-height:17.9952px"><span style=3D"c=
olor:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,sans-serif;font-s=
ize:11.04px;letter-spacing:-0.1104px;line-height:17.9952px">Your weekly acc=
ount summary for</span><br style=3D"margin:0px;color:rgb(102,102,102);font-=
family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:=
-0.1104px;line-height:17.9952px"><span style=3D"color:rgb(102,102,102);font=
-family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px;letter-spacing=
:-0.1104px;line-height:17.9952px">account ending 6920 is below:</span><br s=
tyle=3D"margin:0px;color:rgb(102,102,102);font-family:Verdana,Arial,Helveti=
ca,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-height:17.995=
2px"><br style=3D"margin:0px;color:rgb(102,102,102);font-family:Verdana,Ari=
al,Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-hei=
ght:17.9952px"><span style=3D"color:rgb(102,102,102);font-family:Verdana,Ar=
ial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-he=
ight:17.9952px">Current Balance as at 12:30 26 Sep:=C2=A0</span><br style=
=3D"margin:0px;color:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,s=
ans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-height:17.9952px"=
><span style=3D"color:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,=
sans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-height:17.9952px=
">=C2=A32500.00+</span><br style=3D"margin:0px;color:rgb(102,102,102);font-=
family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:=
-0.1104px;line-height:17.9952px"><span style=3D"color:rgb(102,102,102);font=
-family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px;letter-spacing=
:-0.1104px;line-height:17.9952px">Available Balance as at 12:30 26 Sep:=C2=
=A0</span><br style=3D"margin:0px;color:rgb(102,102,102);font-family:Verdan=
a,Arial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;lin=
e-height:17.9952px"><span style=3D"color:rgb(102,102,102);font-family:Verda=
na,Arial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;li=
ne-height:17.9952px">=C2=A32700.00+</span><br style=3D"margin:0px;color:rgb=
(102,102,102);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:11.0=
4px;letter-spacing:-0.1104px;line-height:17.9952px"><br style=3D"margin:0px=
;color:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,sans-serif;font=
-size:11.04px;letter-spacing:-0.1104px;line-height:17.9952px"><span style=
=3D"color:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,sans-serif;f=
ont-size:11.04px;letter-spacing:-0.1104px;line-height:17.9952px">RECENT TRA=
NSACTIONS:</span><br style=3D"margin:0px;color:rgb(102,102,102);font-family=
:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.110=
4px;line-height:17.9952px"><span style=3D"color:rgb(102,102,102);font-famil=
y:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.11=
04px;line-height:17.9952px">25Sep Transfer =C2=A310.59-</span><br style=3D"=
margin:0px;color:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,sans-=
serif;font-size:11.04px;letter-spacing:-0.1104px;line-height:17.9952px"><sp=
an style=3D"color:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,sans=
-serif;font-size:11.04px;letter-spacing:-0.1104px;line-height:17.9952px">25=
Sep Cheque deposit 150.00+</span><br style=3D"margin:0px;color:rgb(102,102,=
102);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px;lette=
r-spacing:-0.1104px;line-height:17.9952px"><span style=3D"color:rgb(102,102=
,102);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px;lett=
er-spacing:-0.1104px;line-height:17.9952px">24Sep Direct Debit =C2=A33.60-<=
/span><br style=3D"margin:0px;color:rgb(102,102,102);font-family:Verdana,Ar=
ial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-he=
ight:17.9952px"><span style=3D"color:rgb(102,102,102);font-family:Verdana,A=
rial,Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-h=
eight:17.9952px">23Sep Standing order =C2=A323.50-</span><br style=3D"margi=
n:0px;color:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,sans-serif=
;font-size:11.04px;letter-spacing:-0.1104px;line-height:17.9952px"><span st=
yle=3D"color:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,sans-seri=
f;font-size:11.04px;letter-spacing:-0.1104px;line-height:17.9952px">21Sep C=
C payment =C2=A349.00-</span><br style=3D"margin:0px;color:rgb(102,102,102)=
;font-family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px;letter-sp=
acing:-0.1104px;line-height:17.9952px"><br style=3D"margin:0px;color:rgb(10=
2,102,102);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04px=
;letter-spacing:-0.1104px;line-height:17.9952px"><span style=3D"color:rgb(1=
02,102,102);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:11.04p=
x;letter-spacing:-0.1104px;line-height:17.9952px">Regards,</span><br style=
=3D"margin:0px;color:rgb(102,102,102);font-family:Verdana,Arial,Helvetica,s=
ans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-height:17.9952px"=
><br style=3D"margin:0px;color:rgb(102,102,102);font-family:Verdana,Arial,H=
elvetica,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-height:=
17.9952px"><span style=3D"color:rgb(102,102,102);font-family:Verdana,Arial,=
Helvetica,sans-serif;font-size:11.04px;letter-spacing:-0.1104px;line-height=
:17.9952px">Santander Alerts</span></div>
--001a114d944e1c2fac052293164b--
我希望从中得到的是它所说的内容：
Current Balance as at 12:30 26 Sep:
=C2=A32500.00+
Available Balance as at 12:30 26 Sep:
=C2=A32700.00+
我想从这里提取数字2500.00和2700.00。该=C2=A3部分表示£以RawContent形式编写的内容。提取两个数字后，我希望将它们分配给另一张纸上的两个单元格，然后使用该数据制定财务计划等。
您可以使用公式=REGEXEXTRACT(E4,"=C2=A3(\d+\.\d{2})\+")获得第一个匹配项，但第二个则比较棘手。由于您已经在使用脚本，因此我将编写另一个快速函数来提取这些值。
function getBalance(){
var data = SpreadsheetApp.getActiveSheet().getRange(1,1).getValue();
var re = /=C2=A3(\d+\.\d{2})\+/g;
var results = [re.exec(data)[1], re.exec(data)[1]];
return results;
}
这将获取文本，通过使用原始£前缀标识两个可用余额来提取两个可用余额，然后将它们返回到数组中。
然后，您甚至可以=GETBALANCE()从电子表格运行，它将在两行中为您提供余额作为输出。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句