I have some extracted data into excel as a csv file and it contains lots of information, but I'm focused on the Alias. Then I have a list of usernames that has been given to me. What I would like to do is, if the alias/name match, export (extract) all of the data for that alias to a new sheet.
example:
extracted data:
<tbody>
[TD="class: xl65, width: 123"]DisplayName[/TD]
[TD="class: xl65, width: 137"]AccountID[/TD]
[TD="class: xl65, width: 114"]EmailAddress[/TD]
[TD="class: xl65, width: 98"]EnableCalendar[/TD]
[TD="class: xl65, width: 93"]EnableMeeting[/TD]
[TD="class: xl65"]jdoe
[/TD]
[TD="class: xl65"]abcd[/TD]
[TD="class: xl66"]12345-456789[/TD]
[TD="class: xl67"] jdoe@xxx.com [/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"]ssmith[/TD]
[TD="class: xl65"]efgh[/TD]
[TD="class: xl66"]12345-456790[/TD]
[TD="class: xl67"] ssmith@xxx.com [/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"]jjones[/TD]
[TD="class: xl65"]ijkl[/TD]
[TD="class: xl66"]12345-456791[/TD]
[TD="class: xl67"] jjones@xxx.com [/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0
[/TD]
</tbody>
[/TD]
</tbody>
the list that I will need to compare it to:
Name Display Name E-mail Address
jdoe Doe, John jdoe@xxx.com
jjones Jones, Joe jjones@xxx.com
Since jdoe and jjones are the only ones in the list that match the extracted data then I need all of the extracted data for those 2 in a new sheet. Is this possible? Can someone advise me?
example:
extracted data:
<colgroup><col style="mso-width-source:userset;mso-width-alt:3555;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:4380;width:92pt" width="123"> <col style="mso-width-source:userset;mso-width-alt:4864;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:4067;width:86pt" width="114"> <col style="mso-width-source:userset;mso-width-alt:3470;width:73pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:3299;width:70pt" width="93"> </colgroup><tbody> [TD="class: xl65, width: 100"]Alias |
<tbody>
[TD="class: xl65, width: 123"]DisplayName[/TD]
[TD="class: xl65, width: 137"]AccountID[/TD]
[TD="class: xl65, width: 114"]EmailAddress[/TD]
[TD="class: xl65, width: 98"]EnableCalendar[/TD]
[TD="class: xl65, width: 93"]EnableMeeting[/TD]
[TD="class: xl65"]jdoe
[/TD]
[TD="class: xl65"]abcd[/TD]
[TD="class: xl66"]12345-456789[/TD]
[TD="class: xl67"] jdoe@xxx.com [/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"]ssmith[/TD]
[TD="class: xl65"]efgh[/TD]
[TD="class: xl66"]12345-456790[/TD]
[TD="class: xl67"] ssmith@xxx.com [/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"]jjones[/TD]
[TD="class: xl65"]ijkl[/TD]
[TD="class: xl66"]12345-456791[/TD]
[TD="class: xl67"] jjones@xxx.com [/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]0
[/TD]
</tbody>
</tbody>
the list that I will need to compare it to:
Name Display Name E-mail Address
jdoe Doe, John jdoe@xxx.com
jjones Jones, Joe jjones@xxx.com
Since jdoe and jjones are the only ones in the list that match the extracted data then I need all of the extracted data for those 2 in a new sheet. Is this possible? Can someone advise me?