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!
I figured it out! It's working now!
last(split(outputs('Split_Body_Text')[37],''))
The strings I'm extracting are going into my Excel workbook.
But they look like this: ["6300 W Sweetwater Ln Laveen, AZ 85339"] I want the string without the brackets and quotes. i.e. 6300 W Sweetwater Ln Laveen, AZ 85339
Thx for your help!
And what do you want to do with non-empty strings?
I would assume there is a way to trim off the excess garbage.
Apparently my last reply was deleted. Very strange! This is a sample of the output from Split_Body_Text
[
"--------------------------------------------------------------------------------",
"",
"Property Information",
"",
"Property Address",
"",
"6300 W Sweetwater Ln Laveen, AZ 85339",
"",
"Inspection Due Date",
"",
"",
"",
"Gate Access",
"",
"",
"",
"Gated Code",
"",
"",
"",
"HOA Access",
""
]
Show outputs('Split_Body_Text').
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2