This area of the site is dedicated to code snippets for quick and easy reference
This is a quick way to backup table structure and data, this will go out to the system table and query all tables then provide a script to recreate the tables. This is a bit of a hack but works to backup all the rows in your tables. Run the query and it will generate…
Great if you are creating random passwords, more examples at the reference link below. Reference: http://excel.tips.net/T003872_Generating_Random_Strings_of_Characters.html
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/