Rushki1's blog

Truncating text files to extract only email addresses

Hello does anyone know a formula to extract just the email addresses from files with records as follows:;;Athens;Attiki;Greece;20/07/2015;Nao;Sim;;;;1430833559;;Salvador;Bahia;Brazil;20/07/2015;Nao;Sim;;;;3143249011

I have a total of 25,000 records for this extraction so a truncation solution would be appreciated!

The text required for each of the records above is:


Syndicate content