How to make a field have consistent data

[cer5yc]

I have a field in a table for Email Addresses. My problem is the domain names are old. I need to make everything after the @ sign read "@aol.com" and make all the email addresses lower case. Right now there are various domain names and they all need to be consistent.

My table name is "HRFeed". The column name is "Email".

Can someone tell me how to do this?

Thanks!!

 

[Remou]

You can use StrConv, Mid and Instr functions to do this.

 

[webcats]

So for example, if your data is: John_Doe@earthlink.net in a field called Address1, then in a query you can do this:

new_email: Left([Address1],InStr([Address1],"@")-1) & "@aol.com"



-----------------------------------------
Never, ever approach a computer saying, or even thinking, "I will just do this quickly."

 

[cer5yc]

THANK YOU SO MUCH! That worked wonders. Do you happen to know how I can make all the addresses lower case? Some of them are in the file as JOHNS1@aol.com and I need it to read johns1@aol.com

 

[TheAceMan1]

How are ya cer5yc . . .

[blue]webcats[/blue] is on target (just didn't plugin the names). However to stomp on all the addresses, perform the following:

Open a new query. Goto [blue]SQL view[/blue] and paste the following (overwrite Select:

[blue]UPDATE HRFeed SET HRFeed.Email = StrConv(Left([Email],InStr(1,[Email],"@")) & "aol.com",2);[/blue]

Save & name the query, then run it! . . .

thats it! . . .

See Ya! . . . . . .

Be sure to see thread181-473997

 

[cer5yc]

Thanks so much - that worked like a charm!