合并两封邮件中的数据 [英] Merging data in two mails
问题描述
朋友们,
我想从邮件中检索数据.
数据来自两封邮件.我必须拆分并插入到oracle数据库中.
帮助我合并两个数据.这两个邮件不是同时发送的.邮件之间的时间差异为2到6分钟.
例如:
在第一封邮件中:1,36001; 1,36523,1,526341
第二封邮件:V139,U3,B0,O0,T0,S + 162,; 122528N0890088E; 100729130053
这两个字符串是由电子设备生成的,我们必须对数据进行定界并将其插入到同一张表中.
例如
1,36001; 1,36523,1,526341
1是模式
36001是温度1
36523是温度2
526341是另一个温度
下一封邮件数据就像电池电压一样
V139,U3,B0,O0,T0,S + 162,; 122528N0890088E; 100729130053和压力类似data
Hi friends,
I want to retrieve the data from mail.
The data is from two mails. I have to split and insert into oracle database.
Help me in merging the two data. These two mails does not come at same time. The time variation between the mails is 2 to 6 mins.
example:
this in first mail.:1,36001;1,36523,1,526341
second mail : V139,U3,B0,O0,T0,S+162,;122528N0890088E;100729130053
These two strings are generated by the electronic equipments, we have to delimit the datas and insert into a same table.
for example
1,36001;1,36523,1,526341
1 is mode
36001 is temperature 1
36523 is temperature 2
526341 is another temperature
the next mail data is like battery volt like
V139,U3,B0,O0,T0,S+162,;122528N0890088E;100729130053 and pressure like datas
推荐答案
在很短的时间内就必须实现. .
这两个字符串是由电子设备生成的,我们必须对数据进行定界并将其插入同一张表中.
例如
1,36001; 1,36523,1,526341
1是模式
36001是温度1
36523是温度2
526341是另一个温度
下一封邮件数据就像电池电压一样
V139,U3,B0,O0,T0,S + 162,; 122528N0890088E; 100729130053和类似压力的数据
with in short period i had to cimplete this task..
These two strings are generated by the electronic equipments, we have to delimit the datas and insert into a same table.
for example
1,36001;1,36523,1,526341
1 is mode
36001 is temperature 1
36523 is temperature 2
526341 is another temperature
the next mail data is like battery volt like
V139,U3,B0,O0,T0,S+162,;122528N0890088E;100729130053 and pressure like datas
这篇关于合并两封邮件中的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!