You’re offline. This is a read only version of the page.
Announcements
I receive an automated email message with tabular data. I have used the "HTML to Text" function and received the output listed below. I am trying to capture each identifier such as "Name," "Company," "Address," etc. There are seven such fields that I'd like to capture so that they can be displayed in an Excel file across columns.
Search Criteria:
Name
: Wiley Coyote
Company
: Acme Corporation
Address
: 123 Sunset Ln
City
: Palo Alto
State
: CA
Country
: United States
Zip Code
: 98765
Search type:
Hi @ssmith1
Here's one way to do it:
The first 3 actions are Compose actions:
1st Compose - just hit enter. That's how we will split the text to parse
2nd Compose - The text you posted as an example
3rd Compose:
Share
Report
All responses (
Answers (
2,837
split(outputs('Text_to_parse'),outputs('Line_break'))
Use Filter array to get the columns, by putting Compose 3 in the From field and using the following formula (entered in Advanced mode)
@or(not(startsWith(item(), ':')),endswith(item(), ':'))
Here's the result for columns:
If you want values, change the Filter array to:
@startsWith(item(), ':')
Result for values:
