Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
Hi
I have an excel sheet with Columns Running from 1 to 150 - First row is header
Example [TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]Col....[/TD]
[TD]Col120[/TD]
[TD]Col130[/TD]
[TD]Col150[/TD]
[/TR]
[TR]
[TD]principal@alphass.eq.edu.au[/TD]
[TD]0517_PandC@eq.edu.au[/TD]
[TD]EQInternational@dete.qld.gov.au[/TD]
[TD]nmcca106@eq.edu.au[/TD]
[TD]accounts@helpinghandsnetwork.com.au[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]the.principal@wondaiss.eq.edu.au[/TD]
[TD]admin@wondaiss.eq.edu.au[/TD]
[TD]InternationalStudy@murrumbassc.eq.edu.au[/TD]
[TD]UniformShop@tannsandss.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]oakleighoshc@gmail.com[/TD]
[TD][/TD]
[TD]the.principal@nundahss.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to pull out emails with specific terms - Example Principal Email
[TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]Col....[/TD]
[TD]Col120[/TD]
[TD]Col130[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]principal@alphass.eq.edu.au[/TD]
[TD]0517_PandC@eq.edu.au[/TD]
[TD]EQInternational@dete.qld.gov.au[/TD]
[TD]nmcca106@eq.edu.au[/TD]
[TD]accounts@helpinghandsnetwork.com.au[/TD]
[TD]principal@alphass.eq.edu.au[/TD]
[/TR]
[TR]
[TD]the.principal@wondaiss.eq.edu.au[/TD]
[TD]admin@wondaiss.eq.edu.au[/TD]
[TD]InternationalStudy@murrumbassc.eq.edu.au[/TD]
[TD]UniformShop@tannsandss.eq.edu.au[/TD]
[TD][/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]the.principal@wondaiss.eq.edu.au
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD]the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]oakleighoshc@gmail.com[/TD]
[TD][/TD]
[TD]the.principal@nundahss.eq.edu.au[/TD]
[TD][/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]the.principal@nundahss.eq.edu.au
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance
I have an excel sheet with Columns Running from 1 to 150 - First row is header
Example [TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]Col....[/TD]
[TD]Col120[/TD]
[TD]Col130[/TD]
[TD]Col150[/TD]
[/TR]
[TR]
[TD]principal@alphass.eq.edu.au[/TD]
[TD]0517_PandC@eq.edu.au[/TD]
[TD]EQInternational@dete.qld.gov.au[/TD]
[TD]nmcca106@eq.edu.au[/TD]
[TD]accounts@helpinghandsnetwork.com.au[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]the.principal@wondaiss.eq.edu.au[/TD]
[TD]admin@wondaiss.eq.edu.au[/TD]
[TD]InternationalStudy@murrumbassc.eq.edu.au[/TD]
[TD]UniformShop@tannsandss.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]oakleighoshc@gmail.com[/TD]
[TD][/TD]
[TD]the.principal@nundahss.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to pull out emails with specific terms - Example Principal Email
[TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]Col....[/TD]
[TD]Col120[/TD]
[TD]Col130[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]principal@alphass.eq.edu.au[/TD]
[TD]0517_PandC@eq.edu.au[/TD]
[TD]EQInternational@dete.qld.gov.au[/TD]
[TD]nmcca106@eq.edu.au[/TD]
[TD]accounts@helpinghandsnetwork.com.au[/TD]
[TD]principal@alphass.eq.edu.au[/TD]
[/TR]
[TR]
[TD]the.principal@wondaiss.eq.edu.au[/TD]
[TD]admin@wondaiss.eq.edu.au[/TD]
[TD]InternationalStudy@murrumbassc.eq.edu.au[/TD]
[TD]UniformShop@tannsandss.eq.edu.au[/TD]
[TD][/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]the.principal@wondaiss.eq.edu.au
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD]the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]oakleighoshc@gmail.com[/TD]
[TD][/TD]
[TD]the.principal@nundahss.eq.edu.au[/TD]
[TD][/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]the.principal@nundahss.eq.edu.au
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance