Assistance With a Task

>>57869822
Just fire the ones that use lasstpass for bringing the botnet at work.

>>57869889
Ah interesting.
--
So one conundrum is that the lastpass spreadsheet has employee names formatted as:
[[email protected]] as one cell
while the Active Directory spreadsheet has:
[Lastname, Firstname] as one cell.
Fortunately I've split the active directory column into two columns being:
[Lastname] [Firstname].
Can someone who is proficient at excel throw me some ideas as to how I may make it so I can see who does not have last pass yet?
The Active Directory sheet is the one that has all our employees so it is the primary one I will be using. On the Lastpass spreadsheet is everyone who has one. Basically I need to find out who has an entry on ActiveDirectory but does not exist on Lastpass spreadsheet.
Unfortunately ActiveDirectory does not store their [email protected] email.

>>57869822
upload both files and we'll do it for you :^)

i'm no excel expert, so i'd just export relevant data as csv files and process it with bash/sed/etc

>>57869822
You can do this with python and the pandas library

>>57871188

% echo [email protected] | sed -r 's/(.+)\.(.+)@.+/\2, \1/' 
lastname, firstname

>>57871188
>>57871244
>>57871249
I do not know what to do really unfortunately, can someone translate?
Again I've "translated" both excel sheets to share the same "language", having one column have the first name, and the other column have the last name.
How do I find the ActiveDirectory users that have no counterparts in the LastPass Spreadsheet?

File: a.png (66KB, 663x483px) Image search: [Google]

66KB, 663x483px

>>57871399
one way or another, you need to format the strings you want to compare to a common one, then compare and log the results

made a quick-and-dirty example

>>57869822
>works with exel in a enterprise
>doesn't know how to make fucking macros

get out of there and leave that job for someone qualified

>>57869822
>>57871399
is the number/id column the same for both spreadsheets?

>>57871827
I can make them be if that would help.
>>57871694
This would be very helpful if I knew a lick of any programming knowledge, unfortunately the extent of my linguistic skills was making a "play button" for my shitty newgrounds flash in middleshcool.

>>57871881
>This would be very helpful if I knew a lick of any programming knowledge, unfortunately the extent of my linguistic skills was making a "play button" for my shitty newgrounds flash in middleshcool.
gotta start somewhere

if you can't do it in excel, and you can't do it with a shell script, then you have only two options;
a. do it manually
b. learn to use one of the above

>>57871911
So how do I use this shell script? I have notepad++, how do I incorporate it in my excel sheets?

>>57871969
this particular one is for bash, and depends on sed
windows doesn't come with them, but you can get them via;
- cygwin
- that windows 10 ubuntu thing
- linux in a vm

you might be able to do the same with powershell, which windows does come with, but i don't know anything about it

>>57872048
I do have powershell.
Shit.