Expressions 1

[Janice7]

Hi. I have a list of names and e-mail addresses:

John Doe johndoe@company.com
John Smith johnsmith@anothercomapny.com
... ...

I want to strip the domain name from the e-mail address so that only "company.com" and "anothercompany.com" is left.

Can someone help me with creating this expression?

Thanks

Janice

 

[dalchri]

This ought to work:
[tt]
UPDATE YourTable
SET email=Mid(email,Instr(email,'@')+1)
WHERE Instr(email,'@')>0
[/tt]
The Instr function determines the position of the @ character. Then the Mid function returns only the characters after that position. I added a WHERE clause to make certain that you don't update any fields that are missing a @ character.