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
Number of Employees: NUMBER
Phone Number: PHONENUMBER