Delete Local Printers via a Script

A case where a Microsoft Windows print server may once existed and a new print server had been put into place; the local workstations that accessed the printer shares of the original print server no longer require those shares. Here is a script to remove all local printers prior to adding new printers. Source www.experts-exchange.com

Read More »

Use scp command for file transfer in Linux

The goal is to copy files from one Linux computer to another Linux computer. The scp command is the command of choice. To get help, type scp –help, the result is the following usage syntax. Basic syntax is scp source destination on a local Linux computer. However if the source is a remote computer, add the following to the syntax….

Read More »

How to Sort Text Using Notepad++

Notepad++ is a free source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License. For one reason or another, the process for sorting text within Notepad++ seems to elude me. Some text editors have a plugin that is easy to identify, well so does Notepad++, when you…

Read More »

A Julian and Gregorian Calculator using AutoIt

I know that there is a Julian Day Converter that has been around for years. It, however, is no longer supported. The window can sometimes be a little messy to re-size and it is expressed by dd/mm/yyyy not mm/dd/yyyy for which I am more used to. Well, here is my attempt at a calculator using AutoIt and Koda. This calculator…

Read More »

Julian Day Calculator with AutoIT

I know that there is a Julian Day Converter that has been around for years. It, however, is no longer supported. The window can sometimes be a little messy to resize and it is expressed by dd/mm/yyyy not mm/dd/yyyy for which I am more used to. Well, here is my attempt at a calculator using AutoIt and Koda. This calculator…

Read More »

Remove All Pictures from Spreadsheet

Sometimes you may copy and paste a web page into an Excel spreadsheet, the result may be a spreadsheet peppered with pictures throughout. Too many to individually delete. There is a way to remove all pictures from a spreadsheet by using a macro. Press ALT F8 to get the Macro box. Type in a name and edit it. Copy and…

Read More »

Changing the name of a SQL Server Machine

After cloning a Microsoft SQL 2000 Server into a virtual machine and renaming the server, the scheduled Jobs no longer worked. Essentially, the reason is that the jobs were created while using a server with a different server name. The SQL Server will act as if the job originated on a master server, and will not allow changes to that…

Read More »

Microsoft Excel – Turn a “1” into “001”

To convert numbers like 1, 10, 100 to 001,010, and 100 within a Microsoft Excel spreadsheet, there are a couople of ways to accomplish this. Format–>Cells, Number tab, Choose Custom and type 000 into the short box at the right. In Excel 2007: From the Home tab, go to Cells, select Format, then Format Cells. Go to the Number tab,…

Read More »

Useful DOS Commands

From time to time a DOS batch (“bat” or “cmd”) file needs to be written to perform some task or series of tasks. There are various commands that I seem to consistantly search for on the Internet. Here is a list of some of those useful DOS batch commands. How to delete files equal to zero bytes in size. Delete…

Read More »

How to use multiple blockquotes in WordPress using CSS

There was a need to use blockquotes for different uses. Warning, Informational, Stop, Go, or as a blockquote. The possibilities are endless. This is possible by giving the blockquote element a class attribute within your (X)HTML or post, and define the class in the style.css file of your theme. This technique was found here. In this example, where the following…

Read More »

Delete Files and Subfolders from Folder but not that Folder Itself

If you would ever want to use a command line delete all the files and folders from within a folder without deleting the folder itself, a batch file can be constructed. Warning: There are a few things that I discovered while testing this script. Firstly, the CD command, which is part of this script will accept a / character as…

Read More »

How to search and replace text from a very large XML file

There are many ‘solutions’ that exist that will parse through a text file and other utilities that have specific functions designed to parse through an XML file. After trying several applications only one was capable of effeciently search and replace text within (in this case) an XML file that is over 300 MB in size. The whole process took less…

Read More »

DOS Batch – Find and Replace all occurrences of a string with another string

A fantastic write-up for a batch file, DOS Batch – Find and Replace, that allows string substitution in a text file. It parses each line of a text file for a particular string and replaces it with another string. For example, to replace all occurrences of “red” in “color.txt” with “blue” and put the output on the screen. The script…

Read More »

How to wipe a Blackberry 9530 and unlock it to prep for sale

There are several steps to preparing the BlackBerry 9530 phone prior to resale. Remove the old phone number from the phone, factory reset, wipe, unlock, remove the SIM and SD cards. After reviewing many resources, YouTube videos, and finally a couple of interesting utilities, this is all possible. Requirements 9530EastAsia_v5.0.0.1041_P4.2.0.456 Operating System (optional) BlackBerry Swiss Army Knife (“BBSAK”) BlackBerry Reader…

Read More »

Use DOS Batch to show last month date with the date command

Use a DOS script to automate a process where by using the date /T command would return the previous month, rather than the current month. This actually sounds easier than it is. For the desired results, a couple of conditions were considered. Firstly, if in the month of January or one, then the subtracted value of one minus one equals…

Read More »

WordPress SQL Queries for database cleanup

With time your WordPress database may grow out of control. A couple contibuting factors are post revisions, RSS feeds fed through the dashboard. There are plugins that handle basic database optimizations, however, the command line is a quick and dirty way to handle some of these. I have always been aware of the transient RSS entries in the wp_options of…

Read More »

Delete with wildcards from FTP server

Most FTP users use an FTP client to access their FTP server. While there may be a client that is capable of deleting files with wildcards, FileZilla Client does not. After a little research, there is a command available to Windows and Linux users accessible via command line. The command is simply called FTP. Windows / Linux usersAside from some…

Read More »