Parsing text from email and inserting row into Excel

Like (0) Share

Report

Posted on 20 Feb 2023 06:07:33 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!

I have the same question (0)

All responses (6)

Answers (0)

VictorIvanidze 12,868 on 20 Feb 2023 at 07:31:14

Like (0)

Report

Re: Parsing text from email and inserting row into Excel

Show outputs('Split_Body_Text').

Was this reply helpful? Yes No
anm8tr 12 on 20 Feb 2023 at 15:14:03

Like (0)

Report

Re: Parsing text from email and inserting row into Excel

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 20 Feb 2023 at 15:31:41

Like (0)

Report

Re: Parsing text from email and inserting row into Excel

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

Was this reply helpful? Yes No
VictorIvanidze 12,868 on 20 Feb 2023 at 15:46:03

Like (0)

Report

Re: Parsing text from email and inserting row into Excel

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

Was this reply helpful? Yes No
anm8tr 12 on 20 Feb 2023 at 22:21:21

Like (0)

Report

Re: Parsing text from email and inserting row into Excel

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 21 Feb 2023 at 04:24:51

Like (0)

Report

Re: Parsing text from email and inserting row into Excel

I figured it out! It's working now!

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

Was this reply helpful? Yes No