string function to update email address?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 (e-mail address removed). Does anyone have a function that can do
this for you?

Many thanks!
 
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 (e-mail address removed). Does anyone have a function that can do
this for you?

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