Excel Username Mappings
Friday, July 27, 2007
This calculation takes the name from a field and turns it into an account name in the format of first initial + last name as well as first name + last initial.
I created this document as part of a migration mapping of user names from a system that used the first name, last initial format for their user accounts and was moving to first intial, last name.
This will take the information in the first column, find the first character [which is hopefully the first character of the username], then get the string from the first character of the last name to the end of the entire string, and finally adding it all together to make the first initial + last name format.
Excel:
Calc:
This will take the information in the first column, find all the letters from the first character to last character in the first name, and then take the first character that comes after the space between the first name and last name, and finally add them all together to make the firstname + last initial format.
Excel:
Calc:
I'm sure there are Excel gurus out there that could whip this up like nothing, but I thought it was handy and had never used excel for manipulating strings like this before.
Here's an example of the original file:
Excel:username_manipulations.xls
Calc:username_manipulations.ods
I created this document as part of a migration mapping of user names from a system that used the first name, last initial format for their user accounts and was moving to first intial, last name.
This will take the information in the first column, find the first character [which is hopefully the first character of the username], then get the string from the first character of the last name to the end of the entire string, and finally adding it all together to make the first initial + last name format.
Excel:
Calc:
This will take the information in the first column, find all the letters from the first character to last character in the first name, and then take the first character that comes after the space between the first name and last name, and finally add them all together to make the firstname + last initial format.
Excel:
Calc:
Here's an example of the original file:
Excel:username_manipulations.xls
Calc:username_manipulations.ods
The way that I've implemented this technology is by installing the virtual appliance locally at the site being monitored to track individual hosts and services [SMTP, HTTP,etc] and then a remote monitoring machine at my house to keep track of basic connectivity of my client sites. [See diagram]