none
Mid Statement in a Query (Easy for someone) RRS feed

  • Question

  • I need help extracting the information between the [@] and the [.].  For example, on "name@company.com" I need just "company".
    Tuesday, July 12, 2016 1:06 PM

Answers

  • Mid(pole1,InStr(FieldName,"@")+1,InStr(InStr(FieldName,"@"),FieldName,".")-InStr(FieldName,"@")-1) AS domainname


    Michał

    • Marked as answer by Matzke Tuesday, July 12, 2016 1:46 PM
    Tuesday, July 12, 2016 1:46 PM

All replies

  • Mid(pole1,InStr(FieldName,"@")+1,InStr(InStr(FieldName,"@"),FieldName,".")-InStr(FieldName,"@")-1) AS domainname


    Michał

    • Marked as answer by Matzke Tuesday, July 12, 2016 1:46 PM
    Tuesday, July 12, 2016 1:46 PM
  • I need help extracting the information between the [@] and the [.].  For example, on "name@company.com" I need just "company".

    Hi Matzke,

    How do you want to handle the email addresses the contain more than one dots in the domain name?

    Imb.

    Tuesday, July 12, 2016 2:26 PM