Compare Name and Email fields

[jamesfranklin]

Hi,
I'm having three fields
"First_name last_name Email_id"
Marcos Dauder Ricard "Ricard.marcos@uab.cat"
Shyu Mei-Ling "shyu@miami.edu"


I want to check whether firstname or last name are present in email id.


Thanks...................

 

[pr2-eugin]

InStr function should do the trick.. Check out HERE how to use the function..

 

[jamesfranklin]

Hi pr2-eugin,
Thanks for ur reply. I'm new to Access. I don't no how to use that function
Please give some other tips

Thankssss

 

[pr2-eugin]

Did you check out the link I have given with my previous reply? It had the explanation on how to use it.. So where are you stuck up at?

 

[jamesfranklin]

Hi,
Thanks ur reply
Ya i already checked that. but i don't know how to compare the name with email.

Thankssssssss

 

[pr2-eugin]

James what do you wish to do? Do you want to have another Column in the Query result saying NameInEmail with answer Yes or No?? If so..

[NameInEmai] : IIF(InStr([nameFieldName],[emailFieldName])>0, "Yes", "No")

This is my guess.. if you would care to explain a bit more I will be happy to help..

 

[jamesfranklin]

I'm happy from ur reply

No, i don't want to display name is present or not. i want query to check whether first name or last name present in the email address. If first name or last name is not there in the email address means display in query table.

thanksssssss.......

 

[pr2-eugin]

Hello James.. Please make your description more clear next time.. We all love to help, that is the reason you get all these replies.. But if you give us a proper precise description, that will help you and everyone here..

Also try to do something when some reference is given, only by which you will learn.. I have shown you how to use the InStr function, now use it in the WHERE Condition to work out on extracting the information..

If you are stuck in doing that.. show us what you have worked on so far, we will guide you from there on.. we are not here to do your work for you.. we are here to help you to get on the right way.. Please understand the difference.

 

[jamesfranklin]

Hi pr2-eugin,
i attached my file. i need is
For ex:-
givenname San
family name mark
i want check whether givenname or familyname present in email id.

Thanksssss.......

 

[pr2-eugin]

Well you still are not giving a proper description.. What do you want to do with the 'checked' value? How do you know if it does have the givenname or familyname is in the email? What will the query result return? Just Email.*?

Anyway.. I found that you have not used the Instr correctly.. Here is the SELECT..

SELECT Email.*
FROM Email
WHERE (((InStr([email],[givenname]))<>0));

 

[jamesfranklin]

Hi pr2-eugin,
Thank u for ur reply.
Ya i got it. little bit change in the query. anyway thank u very much dude...



i expect another help from u............


Thank u..........

 

[pr2-eugin]

You are welcome.. What is the other help?

 

[jamesfranklin]

Re: Search from google page

Hi pr2-eugin,
I have a table which contain organization name.

Org_name

California University
Karunya university

Take this org_name and search on the google page and extract first link from the page and save next to org_name

ex:

Web Link
http://www.uci.edu/
www.karunya.edu/


Thank u................