Extract data from emails and manipulate

Hello friends,

(@rkelchuri, @Rammohan91, @balupad14, @vvaidya, @ClaytonM, @Florent_Salendres, @MAHESH1, @Gouda_6, @Palaniyappan )
I have a process in which I should perform the following actions:

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 :slight_smile:

A post was merged into an existing topic: Extract data from emails