Hello,
I figured at least one way to extract the info I need from an email and insert into row in Excel. My questions is
how to change the formatting. Long story short, I end up with an array of text and I'm using this formula to extract:
split(outputs('Split_Body_Text')[48],'') it's working but the formatting looks like this inside Excel : ["J004037535"]
How do I get rid of the brackets and quotes?
I have to sift through a lot of text in the emails, it's not a three or four line simple form with 6 words like 99% other examples I see online. I'm extracting only 5 pieces of info but the emails have tons of Html and extraneous text of no use to me.
Thx for any feedback!