Good Day my friends,
I am testing the water with microsoft flows and I was able to extract text from my email, however I would like to delimit the text to be more acurate, I mean get the information per line without capturing information from other lines.
Example, I have the following lines of text in my email, I want to get the information per line, I did it using this structure "
VesselName AS Fiorella (AFI)
Voyage ISL8022
Scenario SHIFT
PortName Port Everglades
Thank you in advance
Walter
Hi @walfredfu,
Could you please share more details about your scenes?
Could you please explain more details about your requeirment?
What is the problem when you create the flow to acheive your needs?
Please share more details so we would try to provide a proper workaround for you.
Best regards,
Alice
Hello Alice,
Thanks for your reply. Here is what I need.
I want to extract the following highlighted text from the body of my email by using microsoft flow:
VesselName AS Fabrizia (AFA)
Voyage ISL8023
PortName Castries, St Lucia
EOSP 2018-06-15 06:12:00
PilotOnBoard 2018-06-15 06:42:00
BerthNo
ArrivedB 2018-06-15 07:18:00
ETD 2018-06-15 13:00:00
NextPort VISTT [1945] 2018-06-16 23:59
MovesForDischarge 29
MovesInTransit 133
NumberOfReefers 1
DRAFTFWDINBERTH 5.3
DRAFTAFTINBERTH 7.1
DelayReason
Remarks
ReportDate 2018-06-15 08:15:00
However the report is dinamyc and the fields that I am trying to get could be differents, in this case "VesselName" AS Fabrizia (AFA) contain 17 characteres but there are some other vessels that contain 10 or 20 characteres. Now the problem is that sometimes the if the charactares contained are 10 or less the field si getting information from the next line... It is combining Vessel Name and Voyage.
Part of email:
VesselName Regula
Voyage CAR8023
What I need is: Regula
This is what I getting - Value extracted from my email: (Is pulling information from the next line " Voyage"
Regula (REG)CAR
This is the structure that i am using to the the information per each line.
User | Count |
---|---|
17 | |
14 | |
13 | |
7 | |
4 |
User | Count |
---|---|
10 | |
5 | |
4 | |
3 | |
3 |