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)
Excel Coulmn A1 “Get me If you can “ =MID(A1,SEARCH(“Get”,A1)+3,SEARCH(“If”,A1)-SEARCH(“Get”,A1)-4)
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
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
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 – 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 Solution:- Open Reporting Services Configuration Manager Connect to your RS server Select ‘Encryption Keys’ from the left pane Press the ‘Delete’ button… Read More
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
=TEXT(IF(CELL(“type”,A1)=”l”,LEFT(A1,FIND(” “,A1)),INT(A1)),”mm/dd/yyyy”)