How to get specific data from E-mail body text


#1

Hi everyone, I have a small problem.

I would need to get specific data from e-mail body which is in format.

E-mail body looks like:

a: 1031023
b: Yes / no
c: 111,43 €
d: true
e: 1193023
f: not given


a: 1433493243
b: Yes / no
c: 123,64 €
d: false
e: 132213
f: Mr. Doe


a: 2495939
b: Yes / no
c: 2231 €
d: unknown
e: 694956
f: not given


I would need to get all the data in separated transaction items to work queue from a to f. One transaction item would held data from a to f, and “----” works as separator in e-mail for different data.

One transaction item in Orchestrator work queue would look as example:

Transaction item 1:
a: 1031023
b: Yes / no
c: 111,43 €
d: true
e: 1193023
f: not given

My idea would be first separate these items by using a and f as telling where new item starts and ends and then read the data per item by using split.

Biggest problem what I have troubles to deal with is how to get these separated data items from the read e-mail body, and especially from the middle of e-mail body. One e-mail can have even more than 20 items to be taken.

Thanks in advance for all help!


#2

you can split the Body Message using new line as a separator, then you cna filter out the rows which are starting with a. b. c. d. e. and f. then you can create a list or data table and out the filtered data in whatever the format you want.