In this video demo I'm going to show you how concatenate strings, as well as the functions LEFT, MID, RIGHT, FIND, TRIM, and LEN, and then how to use them together to get what it is you're looking for. At the end of the demo, we'll touch on the IF function and show you how you can manipulate the table based on some set …
Read MoreI wrote the following PowerShell script so that I could easily watch my GPO changes replicate around the globe, letting me know when I could have someone at a specific site update policy when new policies or changes were rolled out. To use, just replace $gpoGUID = "{12345678-1234-5678-9123-ABCDEFEDCBA0}" with …
Read MoreI recently had to troubleshoot an issue where a number of people were unable to publish to their blog from Microsoft Word 2010. They would get the error Word cannot publish this post, and pressing CTRL+SHIFT+I revealed error 701797 in the dialog box. The same error occurred on both SharePoint 2010 and WordPress. There …
Read MoreThe following AutoIt script will allow you to set the Microsoft Office Registered User Name, Initials, and Company via a script by getting the name information from Active Directory and modifying the keys . This is useful in corporate environments where you don’t want it to have a generic name when you’re being told …
Read More