Replace Invalid Email Format with a Valid One

In Power Query, I have a list of emails that includes invalid emails. I am looking to use M codes to identify and "fix" them. For example, my email list would include something like "1234.my_email_gmail_com@error.invalid.com"

I am looking for Power Query to find similar email addresses, then produce an output of a valid email. For the example above, it should be "my_email@gmail.com"

Essentially, I want to do the following:

• Remove the digits at the front (number of digits varies)
• Remove the "@error.invalid.com"
• Replace the first underscore "_" from the right to "."
• Replace the second underscore "_" from the right to "@"

I'm still new to Power Query, especially with M codes. I appreciate any help and guidance I can get.