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




Compétences : Programmation, Codage

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Sydney, Australia

Nº du projet : #27940144

5 freelances font une offre moyenne de 219 $ pour ce travail


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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
(0 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 15 jours
(0 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)