Querying part data

  • Thread starter Thread starter Alex H
  • Start date Start date
A

Alex H

Hi -
I have two list sof email addresses and I need to run an Unmatched query to
select from the first list all records where there is no match on the email
domain (ie everything after the '@'sign in the email address) .

Could some kind person advise me how I select the string from the '@'

Thanks
 
Alex H said:
Hi -
I have two list sof email addresses and I need to run an Unmatched query
to select from the first list all records where there is no match on the
email domain (ie everything after the '@'sign in the email address) .

Could some kind person advise me how I select the string from the '@'
Click to expand...


Mid$([Domain], Instr([Domain], "@") + 1)

if the field Domain is

(e-mail address removed)

the Mid$ above will give you

here.com


Tom Lake
 
Back
Top