I have a text table in a .txt file in near-markdown type layout on a daily SAP export and emailed and intercepted by Power Automate, similar to this:
-------------------------------------------------------------------------------------------
|PLnt |MRPCn|Material |Material Description |Pln stock|Total stck|
-------------------------------------------------------------------------------------------
|0201 |F4 |202011 |Hyaluronic Acid No. 43 | 0 | 0 |
|0201 |F4 |202104 |Blue 40 NGSTE (Post) | 47 | 47 |
|0201 |F4 |202203 |Nitroglycerine 44 | 49 | 49 |
By near-markdown, I mean that if I put this in the markdown converter online at tableconvert.com it mostly unpacks it into csv but leaves the dashed lines. I don't know what format it really is.
I need to use power-automate to intercept the email with the text file, convert it to a pretty excel, run scripts on that excel (eventually), and then send it on its way.
Is this SAP specific markdown format or is it some other standard? Is there a non manual way to do this? Flow doesn't seem to have any built in methods that I can find. My current plan is to break the txt file into an array and loop through it using the | as a separator and to trim the spaces.
I know there is a way export and email excel SAP with ABAP, but unfortunately I don't have access to that option.