How to open a CSV file that uses Pipe Delimiters in Microsoft Excel

CSV stands for comma separated file, sometimes we don’t want to use comma’s in a CSV file and decide to rather use a Pipe Delimiter | especially in cases where one of the columns contains a paragraph with comma’s in. Open Office provides us with a option to choose the Delimiter when opening CSV files, but MS Excel does not. But luckily theres a way around this. NOTE: This how-to has been based on Windows Vista, but will work on other Windows versions as well. ...

March 24, 2018 · 1 min · 149 words · icarnaghan

How to open Task Manager in Windows 7

Click on Start In the search box above the Start Button type in taskmgr and press enter. This will bring up the Task Manager, or Press CTRL+ALT+DEL together and in the Window that pops-up select Task Manager

March 24, 2018 · 1 min · 37 words · icarnaghan

How to open the Calculator in Windows 7

This will also work in Windows Vista Click on Start In the Search Bar type Calc and press enter

March 24, 2018 · 1 min · 19 words · icarnaghan

How to personalize Windows 7

Windows 7 can be Personalized changing the Themes, Desktop Background, Window Color, Sounds, Screen Savers, Desktop Icons and Mouse Pointers. To Personalize Windows 7 right click on the Desktop and select Personalize. Select the appropriate option to personalize: Themes - Change icons, backgrounds, menus and sound. Desktop Background - Choose or use your own colors and pictures. A slideshow can be started if more than one picture has been selected. Window Color - Change the window color and transparency. Sounds - Change the sounds for different performed task. Screen Savers - Adjust the screensaver that needs to display. Desktop Icons - Add icons to the Desktop. Mouse Pointers - Change how the pointer looks and acts etc

March 24, 2018 · 1 min · 117 words · icarnaghan

How to remove a Linux partition from Windows XP and restoring the Master Boot Record

Open Control Panel Search for and open Administrative Tools Locate Computer Management and then Disk Management There will be a partition named Unknown Partition where the Linux Operating System has been installed Right Click on the partition and Delete Logical Drive After the Logical Drive has been deleted, format the deleted partition with the FAT32 filesystem so that Windows will recognize it. After the above steps have been done, you will need to Restore the Master Boot Record. To restore the Master Boot Record you will need to execute the following DOS commands, you can either use your Windows XP boot disk to do this or the Command Prompt ...

March 24, 2018 · 1 min · 135 words · icarnaghan

How to return a associated array from an single record in the table using Joomla! 2.5 and 1.5 API

Use the loadAssoc() method as in example below $db = $this->getDbo(); $db->getQuery(true); $db->setQuery("SELECT count(id) as count FROM #__database_table"); $count = $db->loadAssoc(); echo $count['count'];

March 24, 2018 · 1 min · 23 words · icarnaghan

How to set the default Email client or any other default application in Windows Vista

It’s easier to select default programs for Windows Vista than Windows XP. Windows Vista includes by default a Default Programs option in the Start Menu. We will show you how to select your Default Email client, but any other default applications can be set exactly the same way. Click on Start and then **Default Programs ** Click on Set your default programs. This will be the first option on the page ...

March 24, 2018 · 1 min · 199 words · icarnaghan

How to shutdown Windows XP via the Command Prompt

First we need to open the Command Prompt Press WINDOWS KEY+R together to open the Run window and type in the command below and hit OK to open Command Prompt. {codecitation type: bash}cmd{/codecitation} Or click on Start->All Programs->Accessories->Command Prompt to open the Command Prompt. Once the Command Prompt window has opened we can type in the ‘shutdown’ command. The shutdown command has many options, below we will use some examples Example 1 Shutdown PC -s = Tells the shutdown command to shutdown {codecitation type: bash}shutdown -s{/codecitation} Example 2 Shutdown PC within 30 seconds -s = Tells the shutdown command to shutdown -t = Specify time followed by a open space followed by the number of seconds {codecitation type: bash}shutdown -s -t 30{/codecitation} Example 3 Shutdown PC within 30 seconds and displaying a message -s = Tells the shutdown command to shutdown -t = Specify time followed by a open space followed by the number of seconds, we add another blank space after the amount of seconds with a message, this message will display when the seconds countdown begins {codecitation type: bash}shutdown -s -t 30 “Ready to shutdown!!! Hurry Up!!!”{/codecitation} Example 4 Canceling the shutdown process (First need to have Command Prompt open) -a = Tells shutdown to cancel {codecitation type: bash}shutdown -a{/codecitation} NOTE: In order to view all options for the shutdown command, open the Command Prompt and enter the command below {codecitation type: bash}shutdown /?{/codecitation} this will display a list of options on how to use this command.

March 24, 2018 · 2 min · 249 words · icarnaghan

How to turn FAST STARTUP on or off in Windows 8

Open Control Panel Click on **System and Security ** Click on **Power Options ** On the left hand menu, click on **Choose what the power buttons do ** Click on **Change settings that are currently unavailable ** All options will become available, untick the tickbox next to **Turn on fast startup (recommended) ...

March 24, 2018 · 1 min · 93 words · icarnaghan

How to Uninstall a program in Windows 7

Click on the START button Select CONTROL PANEL Under PROGRAMS click on UNINSTALL A PROGRAM Select the Program you wish to Uninstall and click on the Uninstall button on the Toolbar

March 24, 2018 · 1 min · 31 words · icarnaghan