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
Date/Time: Sun Sept 10 22:53:32 CEST 2017
OK - Interface 400 = Average IN: 140.626Gbps(50.50%), Average OUT: 519.888Mbps(80.962%)
The regex I used is the following:
But my workflow not works.
Can anyone help me?