Find a word between a string (sentence) using Excel
Excel Coulmn A1 “Get me If you can “ =MID(A1,SEARCH(“Get”,A1)+3,SEARCH(“If”,A1)-SEARCH(“Get”,A1)-4)
Month: February 2016
This product requires Microsoft .Net Framework 4.5 – SharePoint 2013 Installation Error
When you run Microsoft SharePoint Foundation 2013 Setup or SharePoint Server 2013 Setup on a computer that has the Microsoft .NET Framework 4.6 or 4.6.1 installed, you receive the following error message: Setup is unable to proceed due to the following error(s): This product requires… Read More
SharePoint Database Schema Update After installing SharePoint patches
Error Description: The mount operation for the gatherer application has failed because the schema version of the search gatherer database is less than the minimum backwards compatibility schema version supported for this gatherer application. The database might not have been upgraded. Launch an elevated (Run… Read More
WordPress Unicode URL not working
Issue: http://example.com/???????/?????????/ Solution: Follow the below steps 1) Add the Reg. Key manually click start, click run, and then type the following command: reg add HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\w3svc\Parameters /v FastCGIUtf8ServerVariables /t REG_MULTI_SZ /d REQUEST_URI\0PATH_INFO 2 ) Execute the code using cmd.exe as an administrator then paste… Read More
Excel Tutorial – Removing Stamp Time from Dates
Excel Tutorial – Learn how to remove the time stamp from the Excel Date Format simply and quickly using the Find/Replace Function. FIND=” *” and Replace with nothing
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database Solution:- Open Reporting Services Configuration Manager Connect to your RS server Select ‘Encryption Keys’ from the left pane Press the ‘Delete’ button… Read More
How to rename SQL Server after server cloning?
1, Execute the below commands for each instance on the machine. — for a Default Instance sp_dropserver GO sp_addserver , local GO –for a Named Instance sp_dropserver <‘old_physical_server_name\instancename’> GO sp_addserver <‘new_name\instancename’>, local GO 2, Restart the SQL Server services. 3, Execute the below query in… Read More
Removing time element of Long Date Format using Excel
=TEXT(IF(CELL(“type”,A1)=”l”,LEFT(A1,FIND(” “,A1)),INT(A1)),”mm/dd/yyyy”)