Recent content by KO_BayState

I am trying to extract all of the emails within the text file. I just need to get rid of all of the noise around the email address for the most part. whether that means creating a separate query in a process or incorporating additional components into the existing expression.

So I have been looking at another solution to a similar problem and I have a couple of problems but it seems to work slightly better. I've changed the expression to Mid([field1],InStrRev([field1]," ",(,InStr([field1],"@"))+1) and I need to remove <, >, (, ), . and any other miscellaneous...

Thanks for the quick reply and the warm welcome! In addition to the raw text file I have attached on my initial post I have included an example output from the query I posted in my first post. The "testdata" file is the raw text file and "testdata1" is the output after I imported the text file...

I am trying to find a way to extract an email from a large text file that is an output from our email system. I would like to be able to extract the email address using a query or collection of queries. I have been able to extract all of the text that contains the @ symbol. From their I created...