Pulling an email address out of text

[mauddib6]

I read an earlier post on a similar issue and tried to implement it for an email field. It returns the email address, except that instead of a period, it puts a comma. Anny idea why or an alternate solution?

RightWords(Left(From, Position(From, "@", 1, 1)), 1) &"@" & LeftWords(Right(From, Length(From)- Position(From, "@", 1, 1)), 1)

[-Queue-]

I'm receiving a period when I test it. What does your From field look like?

[mauddib6]

"Bob Smiley" <[email protected]>

I tried it in its own file and it worked fine. Don't know what the problem was. Thanks so much for your speedy reply.