I found this code on the Ektron Developer Center (see link below) that pertained mainly to menus but assisted me in getting a folder drill-down so I could add it into my DMS content widget. Similar to the DMS content widget make sure you setup the proper permissions to the…
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
Compare SQL column against another column
In a recent effort to clean up duplicates in my contacts I came across a script to assist me. In my situation I have some contacts that have had the company name inserted as the first/last name. In my case almost all of the records could be modified to null…
Excel Macro – Autofit width and height
AutoFit() is designed to run in your Personal.xlsb with a keyboard function of Ctrl+d to select all columns and rows and then set a temporary width and height to then autofit based on all the content in the worksheet. AutoFitHeight() is designed to run in your Personal.xlsb with a keyboard…
Excel – VLookup – Compare Two Columns/Sheets
Sometimes we need to compare lists in Excel, this function will assist in getting a clean comparison. NOTE: It is best when comparing that all columns are same format (ie. Text, Number, etc.) Going one step further, if you find a match and need a value from the other worksheet…
SQLite – Auto-Increment / Auto Generate GUID
Recently was asked if it’s possible to create an auto-incrementing GUID in SQLite. Here is one approach: In Firefox there is an add-on called SQLite Manager (also available at https://code.google.com/p/sqlite-manager/) Open Firefox, in the “Tools” menu select “SQLite Manager” With SQLite Manager open click on the “Database” menu and select…
MSSQL – Remove Line Breaks
Sometimes you need to remove line breaks or carriage returns, the code below should help. The above script will not work if the column type is TEXT so you must convert it first.
Product Key
This function can be used for various tasks but I happen to use it to make product keys cleaner or easier to read. Before: ABCDEFGHIJKLMNOPQRSTUVWXY After: ABCDE-FGHIJ-KLMNO-PQRST-UVWXY