Rushki1's blog
Truncating text files to extract only email addresses
Submitted by Rushki1 on 21 August, 2015 - 10:26Hello does anyone know a formula to extract just the email addresses from files with records as follows:
aaasilv@terra.com.br;85.72.201.151;Athens;Attiki;Greece;20/07/2015;Nao;Sim;;;;1430833559
aabmeneses@terra.com.br;187.90.44.115;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:
aaasilv@terra.com.br
aabmeneses@terra.com.br
Thanks
»
- 2 comments
- 9673 reads

Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 48 weeks ago
6 years 51 weeks ago
7 years 1 day ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 14 weeks ago
7 years 14 weeks ago
7 years 14 weeks ago