Extract all lines from a body of an email after I find a certain line

(1) Share

Report

Posted on by EDI_Manager

Hello, Sorry but this is one more email body extraction question from a newb.

I want to extract everything out of the body of an email starting at a certain line.

When I hit the line I am looking for, I want that line and every line after that so I can save it to text file on my network.

I've got all lines in an array but I don't know how to find the ones I am looking for.

I included a screen print that shows what I have so far to identify the correct emails and parse the email body into an array. All of this works up to this point.

Starting when I see the line that begins with "Ack/997 FOR RGA"

I want everything in blue.

My end of my array looks like this:

"",
"ZjQcmQRYFpfptBannerEnd",
"",
"BODY OF THE E-MAIL:",
"",
"===========================================",
"",
"Ack/997 FOR RGA 667000176",
"",
" ",
"",
"ISA*00* *00* *14*056671711some *ZZ*mycomp *230906*1801*^*00406*001059296*0*P*>…",
"",
"GS*FA*056671711some*mycomp*20230906*1801*813043*X*004060…",
"",
"ST*997*313044…",
"",
"AK1*AN*667000176…",
"",
"AK2*180*668000176…",
"",
"AK5*A…",
"",
"AK9*A*1*1*1…",
"",
"SE*6*313044…",
"",
"GE*1*813043…",
"",
"IEA*1*001059296…"
]

Categories:

General topics

All responses (7)

Answers (2)

Sort by

trice602 16,679 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @EDIGuy ,

Here's one way to do this and in my test it works well for me. From here, you can clean up the text, etc - I didn't spend anytime on that part, but just wanted to show how I can capture the text in the starting position requested.

In this example, I use the Action Fin text position from the html to text action so I can find the starting position of Ack/997 FOR...

Then from here I use a compose substring to get the text at the start position from the previous step. Again, from here, you can create your new lines, remove quotes, etc, etc but it does successfully capture the data in blue.

substring(body('Html_to_text'),body('Find_text_position'))
EDI_Manager 27 on at

Like
a
(1)

Report
Copy link

Link copied!

Is that text position the character count of where the phase is? I think it set to 127 or 217 or something. How do I use that to extract that line and all lines after that? There are only about 20 lines in the email. I tried lots of things to try to loop from that line to the end but I am not very experienced yet.
trice602 16,679 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @EDIGuy ,

The character position is dynamic and will start wherever that is in the email. My expression captures all lines starting at the phrase to the end so, 20 lines, 50 lines, etc .. doesn't make a difference and you don't loop through lines you are capturing the entire body of the email as a single output.
EDI_Manager 27 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for your help. When I run this I am getting the entire body of the email. Can't tell if I missed something???
This: substring(body('Html_to_text'),body('Find_text_position')) should return everthing after the search phrase?
trice602 16,679 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @EDIGuy ,

Correct. Starts at Ack/997 FOR RGA 667000176 and capture that plus everything below it in the body of the email.
Verified answer

EDI_Manager 27 on at

Like
a
(1)

Report
Copy link

Link copied!

K thank you. I'll give it a try again. Maybe that phrase is in the email body twice or something?
Again, THank you very much for your help!
Verified answer

trice602 16,679 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

You are welcome @EDIGuy - always glad to help. The substring expression is going to find the first one, if there are more than two, but yeah, check it out and mark as a solution if this works for you so others can find this flow too!