AnsweredAssumed Answered

Pentaho Spoon - How to read email and push data in columns of DB table?

Question asked by B523W5TI on Dec 14, 2017
Latest reply on Dec 30, 2017 by B523W5TI

Hello world,


I need to create a workflow with Pentaho Spoon that:

- read mail;

- parse body email (capturing info);

- push data in respective column of Db Table.


I tried with a workflow custom composed with folliwing objects:

- Email messages input;

- Regex evaluation;

- Table output.


Unfortunately I cannot work with regex (parse body to respective column)....


The email has the following body:


Notification Type: AAAAAA

Service: Percentile: Interface vlanxxxx
Address: 99.200.XX.YYY
State: OK

Date/Time: Sun Sept 10 22:53:32 CEST 2017

Additional Info:

- Interface 400 = Average IN: 140.626Gbps(50.50%), Average OUT: 519.888Mbps(80.962%)


The regex I used is the following:


^Notification Type:\s*(.*)$






^Additional Info:\s*(.*)$


But my workflow not works.


Can anyone help me?