This area of the site is dedicated to code snippets for quick and easy reference
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 page that lists these as…
See JSFiddle: JSFiddle Resource: CSS-Tricks.com
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 the first and last name…
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. Windows macOS AutoFitHeight() is designed to run in your Personal.xlsb with a keyboard function of Ctrl+e…
Credit: fatcat1111 @ stackoverflow.com
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.) OR Going one step further, if you find a match and need a value from the other worksheet you can do this.In…
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 “New Database” Type in the…
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.
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