Excel IF statement that operates if a cell CONTAINS a string.

I do not know ho whether many of you have ever had this problem but as I was working on quite a lot of excel data, transforming it for placing in a database using local in file, you will occasionally find that there is data in excel that you may need to represent as a number to enable table linking and foreign keys. For the longest time, I was converting data for foreign keys either manually or using an application of database procedure to create these foreign keys. Continue reading

Share

Tips on how to (re)install grub on a HP ProLiant server

hp-proliant-g6-serverRecently, I needed to install Suse Linux Enterprise Server on a HP Proliant Server. The setup goes smoothly until I had to reboot the system, at which point, I got an error when I tried to boot from the hard disk – Error Loading Operating System. On booting with the installation disk in recovery mode, and trying to get grub to boot into the system on the hard disk, I kept on getting the error that /dev/had could not be found.

Continue reading

Share

How to enable Telnet in Windows Vista / 7

telnetIt’s very rare that I use Telnet ever, so  when developing for Android  and I required to use telnet to interface with their emulator, it took a long time for me to notice that by default it was not enabled with Windows 7 though it was installed. I did some research and found out that this was also true for Windows Vista.

Continue reading

Share