Solved: extract only email address from the column value i...

Anonymous · ‎06-24-2020

Hello,

Requirement is to extract the email address from the column value.

Required Format: Amty63@xyz.com

I tried with LEFT & RIGHT functions.. probably I was doing something wrong. it didn't work.

az38 · ‎06-24-2020

Hi @Anonymous

try

Column = LEFT(Table[Input], LEN(Table[Input]) - 10)

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

az38 · ‎06-24-2020

Hi @Anonymous

try

Column = LEFT(Table[Input], LEN(Table[Input]) - 10)

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

extract only email address from the column value in power BI desktop