string function to update email address?

S

Sandro

I have the folowing problem, I have table with a column that holds email
addresses. The problem is that all email adress have double @ signs.
So all email address have this format: Name@@organization.com.
I would like to be able to create a string function that updates all email
addresses to [email protected]. Does anyone have a function that can do
this for you?

Many thanks!
 
S

Sandro

Thanks Martin, that was really simple, I should have know that!
Thanks again!!!

Martin said:
Replace([your string], "@@", "@")

Sandro said:
I have the folowing problem, I have table with a column that holds email
addresses. The problem is that all email adress have double @ signs.
So all email address have this format: Name@@organization.com.
I would like to be able to create a string function that updates all email
addresses to [email protected]. Does anyone have a function that can do
this for you?

Many thanks!
Click to expand...
Click to expand...
 
Top