Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

@Companies.com to extract

Hi,

Have column with list of email id's

need to have only the text between @ and .com Example: [email protected]. Need formula to extract only 'Gmail' from this email id.

Not only Gmail have many list of companies ID.

 

I have tried with mid(EmailIdcolumn,Find("@",EmailIdColumn+1),Find(".com",EmailIdColumn)-Find("@",EmailIdColumn)-1) 

But getting error :the  Text provided to function 'FInd' could not be found in the given text.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous,

     

    You can simply use SUBSTITUTE and PATHITEM function to find out email name from email address.


    Calculate column formula:

    Middle =
    PATHITEM ( SUBSTITUTE ( SUBSTITUTE ( [Email], "@", "|" ), ".", "|" ), 2 )

     

    Result:

     

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    You can simply use SUBSTITUTE and PATHITEM function to find out email name from email address.


    Calculate column formula:

    Middle =
    PATHITEM ( SUBSTITUTE ( SUBSTITUTE ( [Email], "@", "|" ), ".", "|" ), 2 )

     

    Result:

     

    Regards,

    Xiaoxin Sheng