Closed

PowerBI DAX or M Query function to extract data from email

In Power Query in Power BI looking for expertise to extract data from a Column of fields ([login to view URL]) which contains emails and Extracting contact details from the [login to view URL] and putting it into new columns.

This is an extract of the email it has information above and below, and length varies. So can't just use a single index length

1. Code needs to be able to find the location of the information to be extracted by searching the text

2. Pulling the text out after ": " to the EoL and removing blanks (dedupe blanks)

3. Concatenating First and Last Name together in a single field.

4. Putting all the other information into a column for each field e.g. Job Title Column, Company Column, Number of employees column.

Format of email - extract.

First Name: JOE

Last Name: BLOGGS

Job title: TITLE

Company: COMPANY

Number of Employees: NUMBER

Country: COUNTRY

State: STATE

Request: REQUEST

Email: EMAIL

Phone Number: PHONENUMBER

Notes: NOTES-MULTILINE

Cheers

Skills: Programming, Coding

See more: power query extract email, power query pst file, power query mail, get data from exchange, power query import data from outlook, powerbi email data source, power query exchange contents, query outlook mailbox, extract data email message body using vba, html script extract data email, vba code extract data email, using extract data body email, macro extract data email, excel web query extract data, vba extract data outlook email, macro extract data body email, extract data email, extract data outlook email, extract data access 2003 send email, script email extract data

About the Employer:
( 0 reviews ) Sydney, Australia

Project ID: #27940144

5 freelancers are bidding on average $219 for this job

freelancersandh1

Welcome i am expert in powerbi with excel and i will start work on your project right now message me please

$200 AUD in 7 days
(1 Review)
1.9
(0 Reviews)
0.0
itsolutions3016

Hi There, I have read your requirement and I have already implemented these things in my dashboards and having ability to deliver the quality work within time. Kindly chat with me to discuss this project. Thanks and More

$222 AUD in 15 days
(0 Reviews)
0.0
WardWarrior

Hi, Please see the links below for examples of previously completed projects. I have reviewed your project and I can create an M query statement to split and allocate the relevant data to the fields you have specif More

$200 AUD in 7 days
(0 Reviews)
0.0
girishshetty126

Hello Greetings, Im a certified PowerBI Professional with 10+ years of Technical and Functional experience as Business Intelligence Developer, Data Analysis & Visualization, Advanced Analytics, Data Warehouse Developm More

$222 AUD in 1 day
(0 Reviews)
0.0