extract email address from text field

[dusty]

I need to extract email addresses from a text field...There are a lot of extraneous text characters in this field...the only way I can think of is to find any "word" with an @ symbol...any suggestions on how to extract the word to a result text field? I am dealing with anywhere from 400-600 records at a time. Thank you.

[Lee Smith]

This subject comes up from time to time. Take a look at this thread an file by CobaltSky aka Ray Cologon

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=78240

HTH

Lee

[dusty]

The calc you recommended works great. Thank you all!