Well I came across a situation the other day where a client had data in one column and wanted to extract that data and put elements of that column into other columns. A nice little formula:

In this case, cell A1 contains the original string which you wish to split and place in separate columns. B1 takes all the data to the left of the / sign from A1 and places it in cell B1. C1 Takes all data to the right of the / from cell A1 and places this in Cell C1.

I hope this helps.

Cheerio

• 

Some quick and simple code to convert an ArrayList to a string array in C#

• 

I came across this outstanding post which enables SFTP jailing – this basically prevents SFTP users from navigating your file system

• 

After struggling for sometime, I found a very simple set of instructions which will help you reset you root password in no time at all:

• 

The maximum value for Int32 is 2,147,483,647

Knock yourself out

Cheerio!

• 

So when you add products with options in Opencart and you leave the base price blank, the blank base price will show on your website. Of course this is undesired as the product which you are selling is not free, it just has options, which account for the cost of the product. This is easily solved by a wonderful little little VQMOD plugin developed by our friend Qphoria: http://forum.opencart.com/viewtopic.php?t=51280

Many thanks Q for your hard work!

I have taken the liberty of compiling a zip of all the files needed and how to install them to get the 0 display price sorted:

1. Unzip the file
2. Then unzip vqmod
3. Upload the folder called vqmod to the root dir
4. Go to www.yourdomain.com/vqmod/install
5. Upload the vqmod_opencart.xml to the vqmod/xml directory
6. Refresh your website and look at the products that have options and used to display zero pricing.

Hope this helped!

Cheerio

• 

When you get this error, this is almost always as a result of a misspelt column name.

I recently received this error with the following line of code:

The problem as the misspelt column name synced which as you can see from above was spelt sycned

Double and triple check the spelling of your column names, and you’ll save quite some time googling around

Cheerio

•