Parsing text from email and inserting row into Excel

(0) Share

Report

Posted on by anm8tr

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!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Show outputs('Split_Body_Text').

Was this reply helpful? Yes No
anm8tr 12 on at

Like (0)

Report
Copy link

Link copied!

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",
""
]

Was this reply helpful? Yes No
anm8tr 12 on at

Like (0)

Report
Copy link

Link copied!

I would assume there is a way to trim off the excess garbage.

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

And what do you want to do with non-empty strings?

Was this reply helpful? Yes No
anm8tr 12 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
anm8tr 12 on at

Like (0)

Report
Copy link

Link copied!

I figured it out! It's working now!

last(split(outputs('Split_Body_Text')[37],''))

Was this reply helpful? Yes No