wabarker1
New member
- Joined
- May 19, 2017
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Location
- West Chester, Pennsylvaina
- Excel Version(s)
- 365
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.
I want the output in excel to be in the following form:
| 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:
|
| |||
|
| |||
|
| |||
|
| |||
|
| |||
|
| |||
|
|
