1)read the body of the email and extract all data, in particular I need to extract the two sequences of 8 data in the bosy of the email
(for example the data from VDIVS to 1,0718 in the following body:
From: Foo** Sent: mercoledì 5 aprile 2017 09:59 To: Estero <estero@ .it> Cc: Forex <Foreign@*.it> Subject: FW: Ordine vendita divisa cdg 1158813
1)
VDIVS
1158813
50794547
USD
4.278,13
05-apr-17
07-apr-17
1,0718
2)
VDIVS
1158813
50794547
NOK
4.278,13
05-apr-17
07-apr-17
1,0718
I need to extract also, from the two sequences, the two data USD and NOK and combine them in the string USDNOK, and take only the other 7 data, which are the same in both cases.
Can you please help me in defining a sample workflow?
It’s very urgent for the development of a Bot at the client.
Thank you so much,
Cami