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
Ever have to take a MySQL database and put it in Microsoft SQL? This is a MySQL dump script that will assist you in this conversion. Only problem that I’ve had with it is that you need to review the exported SQL and make sure your version of Microsoft SQL will accept it.
Recently I changed a domain alias for a WordPress site and needed to change the domain in all the pages/posts and this little script came in handy. Typical disclaimer stands, do a full backup before running this and verify you have everything setup correctly. If you have a network site first update your wp-config.php Secondly…
If you have to sanitize your field first it gets ugly but is still possible Reference: http://www.sqlservercurry.com/2010/11/format-phone-numbers-in-sql-server.html