email address to name

[preciouslife-73]

extract name from email address without any non alpha characters for example mickey.l.mouse34@usa.com. to Mickey L Mouse in a column

[Anonymous]

Hi @preciouslife-73 ,

Thanks for reaching out to us.

You can easily do this in Power Query editor.

Here's an example.

Raw data:

Steps:

1.Split column by delimiter.

2.Add a custom to extract the letters.

= Text.Select([email.1],{"a".."z","A".."Z"})

Result:

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[preciouslife-73]

yes but, they are not spaced out by the name, middle and last name.  Is there anyway to combine few commands in the custom column? for example use the delimiter command for the left of @, then replace the decimal with the space, then select the values as you showed me. I tried to use the word "and" to combine all that but it is not working. the process process you provided is good but too many columns. I prefer one column added.

[Anonymous]

Hi @preciouslife-73 ,

Thanks for replying to me.

You want to replace non-letters with spaces, for example, change the text string from"mickey.l.mouse" to "mickey l mouse", right?

If so, you can refer to this similar post:

Solved: how to replace all special character with space - Microsoft Fabric Community

For the consideration you raised about adding multiple columns, this can be integrated into one, or in the last step, remove the columns you don't need.

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly