Selected the range of cells you need to replace. Go to Home > Find & Select > Replace or Ctrl + H Find what: , Replace with: CTRL + SHIFT + J Click Replace All Somehow CTRL + SHIFT + J is registered as a linebreak. Reference: http://stackoverflow.com/questions/14856501/substitute-a-comma-with-a-break-link-in-a-cell
If you have more than one person in the site administration you can sometimes get duplicates, this script will help you find them.
In many databases the address is properly separated into various columns but in a report you want to concatenate them. This simple script will pull them together in one column without causing extra spaces
List out all items in an Ektron menu
This is a collection of a few other scripts that I’ve posted here but this script concatenates widget and alias listings into one column so that you only have one row per content item.
This is another Ektron audit script that will help list PageBuilder content items that have a widget placed on them. The script below is very similar to Ektron Alias With Folder Name
Recently I was asked to format a string into a different format, after some discussion they wanted the integer 500000 to show in a format attributed to India that looks like 5,00,000 The code below shows how best to convert the number, to see the code in action go to https://dotnetfiddle.net/57rggj
This is a import process to import the steps recorded in MSN Health and Fitness Windows Phone app into Fitbit. Place holder for now as I get it working. References: https://github.com/aarondcoleman/Fitbit.NET https://github.com/cbowns/fitbit-oauth-perl/ https://wiki.fitbit.com/display/API/API+PHP+Client http://fitbit.jcs.org/ https://github.com/heyitspavel/fitbitphp/blob/master/fitbitphp.php http://www.staze.org/retrieving-steps-data-fitbit-api/
Recently had a need to be able to switch on/off proxy at will and got tired of going to Internet Explorer options to set/change it. Hopefully someone else will get benefit from this nice tool. Open Visual Studio File -> New Project -> Visual C# – Windows -> Windows Forms Application Add two textbox controls…
Use NuGet, search and install “Json.net” from Newtonsoft Visit json2csharp.com with the sample Json formatted text. json2csharp will create the public class for your json file/text Paste your Json text into the text box and click on the “Generate” button Copy the generated class into your code Create a dataGridView (Windows form) or GridView (Web…