I am attempting to use a pop3 email as a data source but am having issues successfully extracting the data. I have a Sigfox device sending kWh readings every 15 mins from 3 modbus devices. There is one email sent per modbus slave device. It was working well with just one device but since adding 2 more devices it is having trouble extracting data.
The email format is:
**Modbus Slave 1:** Subject: 209start 15398 end Body:209start 15398 end **Modbus Slave 2:** Subject: 210start 2043 end **Modbus Slave 3:**211start 2113 end.
^ formatting modified by Phil
**Modbus Slave 1:** Subject: 209start 15398 end Body:209start 15398 end, **Modbus Slave 2:** Subject: 210start 2043 end & **Modbus Slave 3:**211start 2113 end.
^ original formatting but inside ``` for not getting italics from the stars
The format for the emails sent from the sigfox backend is configurable but it will be the same for each modbus device. The only thing to differentiate each slave device is the message no. (209, 210 & 211). I have RegEx set up for each data point in this format -
209start (.*?) end,
210start (.*?) end,
211start (.*?) end respectively. The emails are being received by Mango and deleted from the inbox but its not extracting the data correctly. Is there anything else I can do here? Thanks.