Power Query Transformation email of text issue

[wabarker1]

I have the following text string in an email, I get about 20 of these a day... i was able to extract the text in power query, but dont know how to extract the first string of text "Orch ID: 13d8caad-10d7-40b8-8b1a-c3e1b64cea1fProcess: Synthes.USA.GPS.EAI.Purchasing.AdvanceShippingNotice.orchProcessASNFromSAP" the email is contsistent it will always begin with Orch and end with ASNfromSAP.

Orch ID: 13d8caad-10d7-40b8-8b1a-c3e1b64cea1fProcess: Synthes.USA.GPS.EAI.Purchasing.AdvanceShippingNotice.orchProcessASNFromSAPJDE PO #: 1855579The following SAP line items failed to convert to JDE line items:SAP line item: 02.130.113-USSAP line item: 02.214.112-USSAP line item: 02.214.011-USSAP line item: 02.214.014-USSAP line item: 02.214.020-USSAP line item: 02.214.109-US

I want the output in excel to be in the following form:

JDE PO #	SAP line item
1855579	02.130.113-US
1855579	02.214.112-US
1855579	02.214.011-US
1855579	02.214.014-US
1855579	02.214.020-US
1855579	02.214.109-US

 

[Dan Bliss]

If you can provide about 10 rows of sample data, I see is I can find a solution for you.